Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: ilaletin@usa.net (Igor Laletin)
Newsgroups: comp.databases.oracle.server
Subject: Re: the output length is just 50 characters
Date: 9 Sep 2001 21:58:22 -0700
Organization: http://groups.google.com/
Lines: 15
Message-ID: <f9226414.0109092058.11c28f7c@posting.google.com>
References: <8c0f1a9e.0109080350.76d66b4@posting.google.com> <3B9A5EBB.A4901B44@netvigator.com> <8c0f1a9e.0109081921.357e44d@posting.google.com>
NNTP-Posting-Host: 203.111.126.130
Content-Type: text/plain; charset=Big5
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1000097902 4412 127.0.0.1 (10 Sep 2001 04:58:22 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Sep 2001 04:58:22 GMT
Xref: easynews comp.databases.oracle.server:117651
X-Received-Date: Sun, 09 Sep 2001 23:44:15 MST (news.easynews.com)

sunxushi@yahoo.com (May) wrote in message news:<8c0f1a9e.0109081921.357e44d@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.