Mmm....Thats why order by piece is there. As the name suggests( which is very rare in oracle naming conventions..:) j/k ) the long SQL is broken into pieces. so be a sport and try it !
Cheers, RS --- dist cash <[EMAIL PROTECTED]> wrote: > I don't think so. V$sqltext even worse. The > v$sqltext definition > > SQL> desc v$sqltext > Name Null? > Type > ----------------------------------------- -------- > ---------------------------- > ADDRESS > RAW(4) > HASH_VALUE > NUMBER > COMMAND_TYPE > NUMBER > PIECE > NUMBER > SQL_TEXT > VARCHAR2(64) > > > It ONLY varchar2(64). > > > > > > > >From: Connor McDonald <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > >Subject: Re: How to check/show long SQL statement? > >Date: Wed, 20 Nov 2002 07:30:01 -0800 > > > >v$sqltext > >order by piece > > > >hth > >connor > > > > --- dist cash <[EMAIL PROTECTED]> wrote: > > > > > > > > > > I need check what is SQL statement runnig on > ORACLE. > > > their have two view > > > v$sql and v$sqlare. The entry "sql_text > > > varchar2(1000)", it is too > > > short to show SQL statement. Some of the sql > > > Statement we use > 3000 > > > characters. Does their has way to check/show > long > > > SQL statement? > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >_________________________________________________________________ > > > Add photos to your messages with MSN 8. Get 2 > months > > > FREE*. > > > http://join.msn.com/?page=features/featuredemail > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: dist cash > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 > > > http://www.fatcity.com > > > San Diego, California -- Mailing list and > web > > > hosting services > > > > >--------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send > an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB > > > ORACLE-L > > > (or the name of mailing list you want to be > removed > > > from). You may > > > also send the HELP command for other information > > > (like subscribing). > > > >===== > >Connor McDonald > >http://www.oracledba.co.uk > >http://www.oaktable.net > > > >"GIVE a man a fish and he will eat for a day. But > TEACH him how to fish, > >and...he will sit in a boat and drink beer all day" > > > >__________________________________________________ > >Do You Yahoo!? > >Everything you'll ever need on one web page > >from News and Sport to Email and Music Charts > >http://uk.my.yahoo.com > >-- > >Please see the official ORACLE-L FAQ: > http://www.orafaq.com > >-- > >Author: =?iso-8859-1?q?Connor=20McDonald?= > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > >San Diego, California -- Mailing list and > web hosting services > >--------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an > E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > >the message BODY, include a line containing: UNSUB > ORACLE-L > >(or the name of mailing list you want to be removed > from). You may > >also send the HELP command for other information > (like subscribing). > > > _________________________________________________________________ > MSN 8 helps eliminate e-mail viruses. Get 2 months > FREE*. > http://join.msn.com/?page=features/virus > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).