I ran out of time and had a couple more things to show today. Here's the first that I ran out of time for.
The thing I meant to show was the ability to use the sql formatter to format your sql in the worksheet into a string for other programming languages. I'll show how to format for java here.
First here's the starting sql. You'll notice I even put in aliased column names quotes.
Now the preferences have to be changed for how to format. I'm going to try to add a simple right click -> Format to Java or something in the future but for now just change this preference.
Now a quick format.
And the sql query is properly escaped and ready to be copy-n-pasted into your favorite java code.
Stuff mostly around Oracle SQL Developer, Data Modeler, the APEX Listener and other general Oracle development thing in general.
Thursday, February 12, 2009
Forgot to show this at RMOUG today
Posted by
Kris Rice
at
5:27 PM
Subscribe to:
Post Comments (Atom)

0 comments:
Post a Comment