dbTalk Databases Forums  

Re: LONG column in SQLPLUS

comp.database.oracle comp.database.oracle


Discuss Re: LONG column in SQLPLUS in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Beth
 
Posts: n/a

Default Re: LONG column in SQLPLUS - 01-05-2004 , 02:25 PM






Hi,

In sqlplus, type the following before you select the long field from
the table:

set long <number>; ie: set long 3000

This value will modify the amount of data in the long field that will
be displayed when you run your query. You can play around with the
number each time until you get the desired results.



"Sławek" <smarcinkowski (AT) poczta (DOT) onet.pl> wrote

Quote:
How to display all field in sqlplus if this field is LONG type? For example
I want to see all trigger_body from query:
SELECT trigger_name,trigger_body FROM all_triggers;
??

Now it displays to me only one piece...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.