The Data Warrior

Another Free Tip for SQL Developer Data Modeler (and a Challenge)

So here is another tip on using Oracle SQL Developer Data Modeler – but this time it is one I will NOT be showing during my session at #KScope13.

In SDDM there is a really nice wizard for building views. Once your view is built, you should probably test it right?

You could generate the DDL, or use DDL Preview, then open up SQL Developer, run the script to build the view, then select from the view to see the results.

Lotta steps, eh?

Or you could simply use the Test Query button on the View Properties dialog.

Press the button, then select a database connection from the drop down list (or create a new one if you need to). This will create a connection to the database and cause the SQL in the view to be executed. If everything works you will see “Query executed successfully”.

” The Test Query button will first check that the SQL will execute

If you want to see the output of the query, just click the Query Results tab.

The Query Results tab lets you examine the output without opening another tool

Pretty cool. And must faster than the old way.

Now for the Challenge:

1. You must be attending KScope13.
2. You must be the first person to find me onsite in New Orleans and tell me you read this post.
3. You then have to show up at my Top Ten Tips session at the conference, join me at the podium and tell the attendees this tip!

Your reward:

1. It might be your first chance to present at an international conference.
2. I will buy you the adult beverage of your choice that evening and chat about SDDM (or another topic of your choosing).

Not a million dollars, but who knows where it might lead or who else you might meet along the way.

So, who’s up to the challenge?

See you in New Orleans.

Oh – if oyu missed the first tip, it is here.

Kent

P.S. Jeff (@thatJeffSmith) and Chet (@OracleNerd) – sorry guys but you are not eligible! (I may buy you beer anyway)