Nerd It Up!

Getting Your Mind Out of the Gutter and Your Line Numbers In

Hopefully your code is cleaner than what runs through this every morning

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

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

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

What's Your Favorite IDE for PL/SQL Programming?

This question really gets my goat!

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

Related Posts Plugin for WordPress, Blogger...