ThatJeffSmith

Tag: ide

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 [...]

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 If we were to create this procedure, we would [...]

How To: Configure TABs in SQL Developer

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 had [...]

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 [...]