Ever wonder what all the red, yellow, and purple marks in your procedure editor are supposed to tell you in the Oracle SQL Developer Procedure Editor? No idea what I’m talking about?

This:

Ohh, pretty colors!
Ohh, pretty colors!

This is the editor trying to help direct you to where you might have problems, instead of you having to to scroll the text looking for the squiggles.

What squiggles, you ask?

These:

See the yellow-dotted lines?
See the yellow-dotted lines?

Mousing over the line shows you the Compiler Warning. You won’t see compiler warnings unless you turn them on in the preferences.

You can also configure the color and style of the PL/SQL Warning and Error squiggles and lines.

Change the type of line, color, etc.
Change the type of line, color, etc.

But Back to the Right Gutter Space

Red – errors.
Yellow – warnings.
Purple – lines with active editor search results.

Mousing over the little block will give you a preview of the text. Clicking on it will take you to that text.

Hover to preview, click to go to
Hover to preview, click to go to

And just in case you haven’t seen the purple ones before, here’s what a search and it’s set of results look like:

See what 'found' text is before going there
See what ‘found’ text is before going there
thatjeffsmith
Author

I'm a Senior Principal Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

Write A Comment