ThatJeffSmith

Oracle SQL Developer v4.0: Breadcrumbs

Hansel and Gretel are in the forest and don’t want to get lost, so Gretel leaves a trail of white pebbles to mark their way. In future adaptations of this Bros. Grimm story, the white pebbles have become ‘breadcrumbs.’

So what does this have to do with SQL Developer?

When working with large bits of PL/SQL code, you now have what we are calling breadcrumbs in the editor footer space. Now in the the world of web design, breadcrumbs have also been used to show the navigation path of your web session. This is a bit different, but I think you’ll get the gist once you see it for yourself.

PL/SQL Editor 'Breadcrumbs'

PL/SQL Editor ‘Breadcrumbs’

The indicator shows where you are in your code block. You can also click on the breadcrumb to navigate back to the beginning of said block. If I were to click on the ‘Generate_OS_File’ bit, that will take me back to the first line of that procedure.

If I were to click on the first bit of the breadcrumb, it will show a ‘table of contents’ of sorts that I can use to navigate to anywhere in the package.

Where do I want to go next?

Where do I want to go next?

The editor will show you in a loop, if statement, exception, etc. If you can’t remember or tell where you’re at inside a large code block, this feature should help you out a bit.

I'm in this package, this procedure, this exception block, and this if statement...

I’m in this package, this procedure, this exception block, and this if statement…

Special thanks to @martindsouza for today’s post idea.