Set the following sqlplus options for spooling a long column. This will avoild truncation of lines to a particular width.
SQL> set trimspool on
SQL> set linesize 20000
SQL> set long 100000000
SQL> set longchunksize 2000
SQL> set pagesize 0
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment