| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to check/show long SQL statement?
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 <hamcdc_at_yahoo.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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 <mccdba_at_hotmail.com> 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: mccdba_at_hotmail.com
> >
> > 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: ListGuru_at_fatcity.com (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: hamcdc_at_yahoo.co.uk
>
>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: ListGuru_at_fatcity.com (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: mccdba_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Wed Nov 20 2002 - 10:59:59 CST
 |
 |