Putting a condition on spool -


i'm trying put condition on spool. want file created if query returns @ least 1 row.

define csvfile=dump_emp.csv spool &&csvfile  select emp_no||','||emp_name||','||deleted emp_table deleted = 0; spool off 


Comments