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 -- http://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.