Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Formating sql_text in v$sqltext
On 16 Jan 2002 16:39:17 -0800, bchorng_at_yahoo.com (Bass Chorng) wrote:
>Does anybody have a good way to format sql_Text in v$sqltext so
>that it can be spooled and executed ?
>
>The only way I know is manually join the pieces in editor which can
>take forever if the sql_text is huge.
>
>I know there is a new view in 8i v$sqltext_with_new_lines which
>is supposed to do something, but whatever that is, I haven't
>seen it.
>
>Thanks.
>
>-Bass Chorng
Return the sql as submitted by the client program.
And the view already existed in Oracle 7!
It has advantages to have *old* knowledge!
What do you need more?
Hth
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Wed Jan 16 2002 - 23:48:12 CST