Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

querying long dataype

Status
Not open for further replies.
DoubleH

DoubleH

Programmer
Dec 17, 2001
58
GB
hi,
i have a problem when i query a long data type in SQL plus running on Solaris. I am not able to get the full length of the data. Even after setting.
sql> set long 20000...

can anyone give me a solution.

Thanks & Regards,
DoubleH
 
Sort by date Sort by votes
Try this:

set long 50000 arraysize 1

Talent is what you possess;
genius is what possesses you

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

billo102
  • Locked
  • Question
"Select * from view" takes a very long time,on second attempt 1
Replies
2
Views
357
billo102
billo102
cmmrfrds
  • Locked
  • Question
How to get data from a LONG data type 1
Replies
8
Views
1K
sem
sem
kjv1611
  • Locked
  • Question
CREATE.. SELECT FROM PLAN_TABLE - illegal LONG datatype
Replies
4
Views
216
kjv1611
kjv1611
TStriker
  • Locked
  • Question
Replacing Characters in Long Data Type
Replies
6
Views
301
TStriker
TStriker
scottyjohn
  • Locked
  • Question
Querying values from different records to show as one record? 1
Replies
8
Views
200
scottyjohn
scottyjohn

Part and Inventory Search

Sponsor

Back
Top