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 <mccdba_at_hotmail.com> 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 <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).
>
>
>
> 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: 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).
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: rajan_sakthi_at_yahoo.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 - 11:14:48 CST
