RE: SQL Beautifier

  • From: "Blanchard, William" <wblanchard@xxxxxxxxxxxxxxxxxxxx>
  • To: <jkstill@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 May 2010 17:23:12 -0500

Vim?!?  That's "cmd line".

 

 

WGB

 

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Wednesday, May 05, 2010 5:20 PM
To: Oracle-L Freelists
Cc: Greg Rahn
Subject: Re: SQL Beautifier

 

So far everyone has missed the 'cmd line' requirement.

 

Greg, you might try this one:
http://www.dbainfopower.com/dbaip_SQLreview.php

 

It doesn't seem to know Oracle specific things such as decode(), and
does not

seem configurable.

 

But given some ugly SQL it does a fair job of making it legible.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com




On Wed, May 5, 2010 at 12:32 PM, Michael Moore <michaeljmoore@xxxxxxxxx>
wrote:

http://www.dpriver.com/pp/sqlformat.htm

 

is free online and does a pretty nice job

Mike

 

On Wed, May 5, 2010 at 10:54 AM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
wrote:

Anyone know of a good open source/free SQL Beautifier (similar to cb
or bcpp for C/C++) to run via command line on Unix/Linux?

--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l



 

 



-

This email and any information, files, or materials transmitted with it
are confidential and are solely for the use of the intended recipient.
If you have received this email in error, please delete it and notify
the sender.


Other related posts: