Re: SQL Beautifier

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 May 2010 15:20:29 -0700

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
>
> <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
>>
>>
>>
>

Other related posts: