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       
 
  
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
Post a Comment