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 …

OT: Reading List

thatjeffsmith Database Stuff 0 Comments

I needed to publish a blog post this week, but instead of writing new content, I thought I’d share with you things I’ve written in other places. In no particular order: I Installed SQL Developer, Now What? – Medium REST for the DB Professional – What’s in it for you? – UKOUG Scene Automatic REST – Oracle Magazine Are Oracle’s …

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 …

Help! Where do you go for help with Oracle?

thatjeffsmith Database Stuff 9 Comments

I’m running a week long poll on Twitter. After Google, where do you go for Oracle help, first? Please answer, then RT. If 'other', please specify in your RT. — Jeff Smith 🥃 ☜ (@thatjeffsmith) October 20, 2017 The problem with Twitter is that you’re limited to only 140 characters, so I’m afraid I failed to adequately word the question. …

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 …