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... |