You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common. And as a child of the 80’s television, my brain has been properly warped. So here is your Christmas themed SQL Developer ‘trick.’ Every look under the tree, and your first reaction is to be a little disappointed in …
OT: Bad Tools Lead to Overly Verbose Code?
For some reason I decided to re-join a discussion in the SQL community from way back in 2012. THIS => "tbl_ is a tell for bad database design" via @datachick http://t.co/hq2BH73xic sorry @SQLRockstar — Jeff Smith (@thatjeffsmith) May 28, 2015 Karen started it, Thomas ran with it, and I decided I had to throw my 2 cents into it as …
Customizing File Extensions for Your PL/SQL Code
You may wish to store your PL/SQL code in files with file extensions other than our defaults. We ship with .klr, .pkb, .pkh, .pks, .plb, .pls as associated file types for our PL/SQL editor and for opening said files on your machine with SQL Developer. But maybe at XYZ Incorporated, you keep your package bodies in files of type .bdy …
Getting Your Mind Out of the Gutter and Your Line Numbers In
I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’ is in the world of programming and database GUIs. I found a good definition on Quantum Whale, a .NET component developer, and I’m going to quote them: Gutter: The gutter area …
Viewing PLSQL Compilation Errors in Oracle SQL Developer
A question that comes up fairly frequently revolves around how to see your errors when working with PL/SQL in SQL Developer. Most folks are probably working in the worksheet – this is the default editor for your connection. Let’s take a look at this sample program CREATE OR REPLACE PROCEDURE do_nothing IS BEGIN dbms_output.put(sysdate); this should probably error OUT, RIGHT? …
How To: Configure TABs in SQL Developer
Update for version 4.2 and higher. As often happens, my ideas for blog posts are provided by end users asking for help. Sometimes I know the answer, sometimes I don’t. This is one of the latter cases. Chet AKA @oraclenerd asked me: ‘Tell me how to find the preference in sqldev to make a tab 2 spaces?’ I knew it …
What’s Your Favorite IDE for PL/SQL Programming?
I stumbled upon an interesting discussion in the ODTUG group on LinkedIn this weekend. A vendor is doing some research I suppose and wanted to know who enjoyed using what IDE and why. Here’s the original question: In your opinion which is the best IDE for PL/SQL programming and why? e.g. PL/SQL Developer, Toad, Oracle SQL Developer. To participate in …