I'm trying to put a condition on spool. I want the file to be created only if my query returns at least one row.
define csvFile=DUMP_EMP.csv
spool &&csvFile
SELECT EMP_NO||','||EMP_NAME||','||DELETED
FROM EMP_TABLE
WHERE DELETED = 0;
spool off
Asked
Active
Viewed 92 times
0
-
Which SQL tool is that? And which DBMS? – May 08 '15 at 12:29
-
http://stackoverflow.com/questions/28967600/spool-command-doesnt-save-result-in-query – Ajay Pandya May 08 '15 at 12:30