asked
spool sqlplus results to out
I found and used this query to spool out, but I am getting an error. 2. SET UNDERLINE OFF 3. SET COLSEP ',' 4. SET LINES 100 PAGES 100 5. SET FEEDBACK off 6. Spool C:\Export\EMP.csv 9. SELECT * FROM EMP; 11. Spool OFF error message: illegal spool command usage spool { | OFF | OUT } where file_name.[.ext] [CRE[ATE | REP[LACE | APP[END] Any solutions to the proper usage to write to an output file? Thanks powerdrivehp
It has been a while since I worked with Oracle. Have you seen/looked at this documentation?
http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SP33/ch4.htm#toc029
15 People are following this question.
