I’ve been tweaking how my SQL Developer application looks and feels for a long time. Someone saw my desktop and wanted to know how to make theirs look like mine, hence this post. I realize beauty in in the eye of the beholder, but if you behold what I behold, then here’s how to get there. I recently came across …
PLSQL Code Editor Tricks – Preview Code Doc & Test Queries
Someone asked: @thatjeffsmith Great blog! Is there a way to display DB Doc in SQL Developer like in Java IDEs with Java doc while being in Code editor? — Sebastian Köll (@s_koell) December 1, 2016 And here’s the answer – Yes! First, let’s talk about PLDoc, and how it works in SQL Developer. All caught up? Great. Now let’s show …
Formatter Improvements in v4.2
The old formatter, the code that’s used to format your code from v1 to version 4.1 was based on some pattern matching code and expressions. It was very limited, and didn’t like a lot of syntax and coding styles common in Oracle code. It also wasn’t very flexible. So we built a new engine. One that takes advantage of our …
TABs in Your Code?
Not to start a religious war, but white space in your code can cause havoc when you’re doing code compares and versioning. Some folks like tabs, others prefer to control how their code looks regardless of the editor’s tab display options. From what I can tell, SQL Developer’s code editors won’t even let you insert a tab into them – …
SQL Editor Code Templates: A Must-Know Trick
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 …
Oracle SQL Developer Code Reports
It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up. Today, about 40 of us in Raleigh/Durham watched David Mann [Twitter] demonstrate lots …
30 SQL Developer Tips in 30 Days, Day 10: Compare Stuff Side By Side
We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B. So let’s look at a few scenarios. Execution Plans or Autotrace Runs Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila. Looking at Objects, Side By Side So …
Oracle SQL Developer: Code on Demand
I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… SELECT SYS_CONTEXT (’USERENV’, ‘SID’) FROM DUAL; …but I’m lazy. So this: The Setup Open your preferences and go to the …
Trailing or Leading Commas?
For me, it’s leading. If I have a code or syntax problem, I find it easier to see the line missing the comma if I can look at the first char position. Of course you may say that’s crazy, and any reasonable programmer would demand trailing commas. I’m guessing your IDE offers formatting options that allow you to choose what …
Date Night
For most couples, ‘date night’ is something to look forward to, but unfortunately does not come around often enough. For others, even the word ‘date’ sends a chill down their spine. It’s not an adverse reaction to their partner, but rather a unpleasant reminder to the daily toil that is working with DATE formatted data in their relational database. Wow, …