When you start working with 12c, if you want to freak out (sorry, GRAB the attention of) your co-workers or folks attending your presentation, try this:
- Open a worksheet
- Write a simple query against a view, or a data dictionary view
- Mouse over the SELECT and wait…
Should just take a second or so…
So we’re now seeing the SQL ‘behind the SQL’ – an MTV spinoff I pitched that that never really took off.
You don’t have to expand it, you can just ‘peak’ into the SQL to see what it’s doing. If you do click on the hyperlinked text, it will replace your query in the worksheet.
And now my 2 line query is almost 400 lines.
So the Fun or Magic Part
In your preferences, switch the SQL Expand indicator to ‘white’ – so it looks like you can just cast your magic spell on demand.
It’s the ‘Disconnected Join Graph’ item, which is apparently translates mathematically to some sort of SQL thing that some of our code insight features key in on, specifically when we add the GROUP BYs for you.