The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer’ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no matter how much money was invested in BI, reporting, and databases – at the end of the day, it’s going…
‘Make the editor work like Sublime Text or Crimson!’ So goes the several dozen requests I get each year. Well, in version 4.1, we’ve got something I think you’ll like. It’s a bit different than column text edit modes – but it allows for the same idea, and it’s even more powerful…I think. You can set the multi-cursor ‘hot key’ in the preferences: You like? @thatjeffsmith Does it count as "lifeless geek" if I find…
Updated December 1, 2020 – after some reports from folks having issues on Big Sur, I added some additional details around troubleshooting. I have ran into a few issues getting SQL Developer version X.Y.Z on my Mac Mini, and I’ve seen a few questions online today now that Big Sur is available. This usually happens as folks get new hardware or as updates are applied to their machines…something quits working. It usually boils down to…
The SQL Developer team has been steadily adding features tailored to the DBA since the version 3.0 release. This steady march continues with version 4.1. The DBA feature I want to talk about today is the Instance Viewer. To open it, you’ll need: SQL Developer 4.1 JDK 8 – this screen uses Java FX, and it’s designed with Java 8 a very high privileged account – I’m using SYS b/c I can Pst! We updated…
We have a new version of SQL Developer Data Modeler for you to check out – version 4.1. It’s an ‘EA’ – or early adopter. So, no official support – all feedback should be provided via the OTN Forum/Community. It requires Java 8. If you see a message about not supporting Java 8 – ignore that and just click ‘OK.’ You can read all about it and download it here. I’ll be blogging about the…
Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going to get the questioner, and you, very close to what you’re looking for. Set These Formatter Preferences One comma per…
Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again. While we’re on this page, there’s lots and lots of cool things you can fiddle with here. For example, ‘SELECTED TEXT.’ And of course you can use this preferences page to setup a more classic ‘green-screen coding’ display..…
Oracle SQL Developer is a tool. My general rule for using tools boils down to – if the tool is making it harder to do the job you’re using it for, you’re either ‘doing it wrong’ or you have the wrong tool. Sorry for the long setup, but I had someone approach me at the DOAG conference in Nuremberg this week with the following request: I cannot really use your tool to work with my…
Updated 17 April, 2020: This feature now supports AutoReplace Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works! But, I was getting distracted by a bit of code that LOOKED like it was DOCS related, yet wasn’t… So if it’s not coming from the docs, where is it coming…
My work machine is a Dell laptop running Windows 7. My home machine is a MacBook Air running OS X Yosemite. 98% (made up number) of the posts on this site were written using my Windows machine. But now that I’ve discovered that my SnagIt license is also valid on my Mac, I’m trying to do more writing there. It’s also a good way to see how the other 10% of our users work, live,…
