Re: "pretty Oracle SQL" utility

On Fri, 09 May 2003 12:14:53 -0400, Ramkumar Krishnan <Ramkumar.Krishnan_at_oracle.com> wrote:

>Could you pls point me to an utility that
>returns "prettied" SQL given an arbitrary
>SQL input (Oracle8i SQL and above would be
>great, but if absent, Oraclev7 is fine for
>starts). Found this:
>www.pickledbeans.com/scripts/Perl/prettysql.txt
>from Google, but I got a 404 Error during
>access.
>
>Thank you for your time and response.

 PL/SQL Developer has a 'beautifier' option that does a moderate job of making jumbled SQL readable; enough to get started on tidying it up anyway.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)