Formating sql_text in v$sqltext

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 Received on Wed Jan 16 2002 - 18:39:17 CST