Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export data (a student's question)
Try this:
SET LINESIZE 1000
SET PAGESIZE 0
SET TRIMSPOOL ON
SET FEEDBACK OFF
SET TERMOUT OFF
SPOOL employee.TXT
Select * from employee;
SPOOL OFF
Received on Fri Feb 05 1999 - 08:47:30 CST