Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for some util to format sql statements
As Mr. Sybrand Bakker pointed out. Toad is probably the best SQL editor I've come across www.quest.com
In article <91b7e7$3jf4g$6_at_ID-62141.news.dfncis.de>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> First you should start using v$sqltext_with_newlines
> order by piece.
> This will probably not completely satisfy you, but at least it is a
start.
> Statements dumped that way can be copied and pasted into Toad or
whatever.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Scott Watson" <swatson_at_datachest.com> wrote in message
> news:91am45$521679_at_NWNEWS.PCT.EDU...
> > Does anyone have a utility to format sql statements from V$SQLTEXT
or some
> > other location where we can extract SQL.
> >
> > Thanks,
> > Scott.
> >
> >
>
>
Sent via Deja.com
http://www.deja.com/
Received on Thu Dec 14 2000 - 19:30:10 CST