Coming Soon: A More Forgiving Formatter

thatjeffsmith SQL Developer 11 Comments

For 17.4, the formatter will attempt to format invalid SQL for you. If the parser runs into a problem recognizing your code, it will format it as much as it can. But that’s not all. It will ALSO go to the end of your statement, and traverse the SQL in the other direction and continue formatting as far as it …

Learning Oracle SQL Developer: The Video Hits

thatjeffsmith SQL Developer 2 Comments

I’ve got short videos for you, 2-10 minutes. I’ve got 20 minute videos. And I’ve got monster, hour long videos. 24 in total, covering everything from how to use the PL/SQL debugger, to building REST Services, to just writing better SELECT * queries. Send me your requests, always happy to build more. I just wish I had a voice made …

Can’t Remember Your Keyboard Shortcuts? Try the Quick Action Panel.

thatjeffsmith SQL Developer 6 Comments

Quick post today. If you want to do something, but can’t remember the keyboard sequence, or can’t find the button, try opening the Quick Action panel. It’s available under the Tools menu. It offers a few features. You can search. You can see the keyboard shortcuts. And you can activate the feature immediately by double-clicking on the item. Like, I …

Version 17.3(.1!) is Now Available

thatjeffsmith SQL Developer 18 Comments

We released SQL Developer version 17.3 while I was at Oracle Open World, so I didn’t have time to really blog it. Plus, we found this REALLY annoying bug. Obviously this was ‘no bueno’ – so we put out a patch. Version 17.3.1 is available now. What’s New in 17.3? Mostly bug fixes. We identified issues from 17.2 and fixed …

Opening Unshared Worksheets via the Keyboard

thatjeffsmith SQL Developer 0 Comments

Customer Question: How can I open an unshared worksheet using just the keyboard? Ctrl+Shift+N on an existing worksheet is the easy answer. Customer Followup Question: But, if you’re currently ON an existing unshared worksheet, this won’t work. Then, you need to hit ALT+F10. Jeff, What is an Unshared Worksheet? An unshared worksheet is a SQL worksheet that has a dedicated …