V$sqltext has the entire "sql_text" in 64 byte chunks.

Ian MacGregor
Stanford Linear Accelerator Center
[Email address protected]

-----Original Message-----
From: Teffany Harris
To: LazyDBA.com Discussion
Sent: 6/2/2004 6:50 AM
Subject: V$SQLAREA view only displays the first 80 character of sql statement

Hi all,
The V$SQLAREA view only displays the first eighty characters of the
SQL_TEXT
field is it possible to view the whole sql statement? If so what do I
need
to do?

Thanks



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page