Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for some util to format sql statements

Re: Looking for some util to format sql statements

From: <newguysanfran_at_my-deja.com>
Date: Fri, 15 Dec 2000 01:30:10 GMT
Message-ID: <91bs72$qv0$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US