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
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