Re: How to extract table contents to files?

Bosco Tsang (btsang_at_ctsc.hkbc.hk) wrote:
: Thanks to those replied.
 

: : spool filename
: : select * from table;
: : spool off
 

: When I use the above statement, and created the file, the system just hang
: after displaying the select * from table; statement when I exit sqlplus and
: view it using either more, cat or even emacs editor. Why?

Try to add 'set pause off'(or something like that) into your script. Henry. Received on Wed Jan 04 1995 - 16:17:36 CET