Re: the output length is just 50 characters

sunxushi_at_yahoo.com (May) wrote in message news:<8c0f1a9e.0109081921.357e44d_at_posting.google.com>...
> even i set them to 200000, the same

Sure. It's nothing to do with 'set long'. v$sqltext_with_newlines.sqltext is varchar2(64). An sql statement is divided into pieces of 64 (or less) bytes. If you need the all of it, try:
select sql_text
from v$sqltext_with_newlines
where address = 'address-of-sql-u-r-interested-in'   and hash_value = 'hash_value-of-sql-u-r-interested-in' order by piece;

Regards,
Igor. Received on Sun Sep 09 2001 - 23:58:22 CDT