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 -> Very long queries in V$SQLTEXT

Very long queries in V$SQLTEXT

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Nov 1999 20:55:45 +0800
Message-ID: <383BE051.68D7@yahoo.com>


I'm at site where there seems to be competition to write the longest SQL's in the world. Once they get above 1000 chars, the usefulness of V$SQL and V$SQLAREA disappears.

So I've been using V$SQLTEXT - which is fine except for all queries created by Oracle Discoverer. In these cases, V$SQLTEXT returns basically nonsense.

Can anyone assist ? Posts of samples available...

--



Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."
Received on Wed Nov 24 1999 - 06:55:45 CST

Original text of this message

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