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: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Fri, 12 Jan 2001 10:21:05 -0000
Message-ID: <93mlvm$hlf$1@kermit.esat.net>

You can but pl/formatter for toad.

newguysanfran_at_my-deja.com wrote in message <93mfga$sql$1_at_nnrp1.deja.com>...
>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 - 04:21:05 CST

Original text of this message

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