ThatJeffSmith

Semantic Analysis Info Tips in Oracle SQL Developer 4.0

A new feature in Oracle SQL Developer version 4.0 offers to address grammatical issues with your SQL statements. We call these indicators ‘Semantic Analysis Info Tips.’

The easiest way to see one of these ‘tips’ is to try out your favorite sql statement in a worksheet:

SELECT * FROM scott.emp;
The 'evil' SPLAT draws the ire of the SQL Developer grammar checker

The ‘evil’ SPLAT draws the ire of the SQL Developer grammar checker

Accessing the ‘Tip’

Place your mouse over the red squiggle line indicator…

Don't click, just mouse hover to activate the tip

Don’t click, just mouse hover to activate the tip

Once the tip is available, you can invoke the grammar ‘fix’ by clicking on the hyperlinked text. You can undo the change using your standard UNDO, e.g. Ctrl+Z in Windows.

The ‘explode *’ info tip works for one or more tables in your SELECT – try it out!

What Other Things Can It Advise Me On?

Remember the ‘Auto Group By’ feature? Well that’s been replaced by a semantic info analysis tip. Don’t remember?

If you need to add a GROUP BY, we’ll help you – no more ‘Automatic’ adding it to your query. I find this VERY nice. The ‘automatic’ behaviors in an IDE tend to annoy the more experienced developers, so making this an ‘on demand’ feature should prevent the tool from getting in your way.

We’ll add more of these grammar checks going forward. If you have ideas, please share!

I hate this, how do I turn it off?

It’s in the preferences – disable it on the Code Editor page.

It's on by default...

It’s on by default…

I have a hard time seeing the grammar squiggle

The mark up ‘lines’ and ‘squiggles’ are configurable!

Open the Preferences and go to the PL/SQL Syntax Colors page under ‘Code Editor.’ You’ll want to look for the ‘Disconnected Join Graph’ entry.

Change the type of line, color, etc.

Change the type of line, color, etc.

I’ll be publishing more 4.0-related posts over the next few weeks. Be sure to check back here often to learn more about our newest version of SQL Developer!