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
I've recently switch, or at least am attempting to do my development in KDE/Red Hat Linux 7.0. However I am really used to using Toad. Does anybody know of a tool that I can use?
Thanks,
Bryan
In article <91bs72$qv0$1_at_nnrp1.deja.com>,
newguysanfran_at_my-deja.com wrote:
> 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/
>
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 12 2001 - 02:33:14 CST