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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Dec 2000 20:13:17 +0100
Message-ID: <91b7e7$3jf4g$6@ID-62141.news.dfncis.de>

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.
>
>
Received on Thu Dec 14 2000 - 13:13:17 CST

Original text of this message

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