This does not work either:
--
set termout off;
set newpage none;
set recsep off;
set echo off; -- suppress showing sql in result set
set feedback off; -- eliminate row count message
set heading off;
set linesize 300; -- make line long enough to hold data
set pagesize 0; -- suppress headings and page breaks
column sysd new_value sysd noprint;
select to_char(sysdate,'yyyymmdd') sysd from dual;
column syst new_value syst noprint
select to_char(sysdate,'hhmmss') syst from dual;
--
spool F:\MyPrintToPdf\xyz-&sysd..&syst..txt
--
select poc_insured_policy_id||chr(9)
||insured_fein||chr(9)
||insured_name||chr(9)
||insured_address_1||chr(9)
||insured_address_2||chr(9)
||insured_city||chr(9)
||insured_state||chr(9)
||insured_postal_code||chr(9)
||policy_number||chr(9)
||policy_effective_date||chr(9)
||policy_expiration_date||chr(9)
from c5;
--
spool off;
Works in SQL-Plus though
--
set termout off;
set newpage none;
set recsep off;
set echo off; -- suppress showing sql in result set
set feedback off; -- eliminate row count message
set heading off;
set linesize 300; -- make line long enough to hold data
set pagesize 0; -- suppress headings and page breaks
column sysd new_value sysd noprint;
select to_char(sysdate,'yyyymmdd') sysd from dual;
column syst new_value syst noprint
select to_char(sysdate,'hhmmss') syst from dual;
--
spool F:\MyPrintToPdf\xyz-&sysd..&syst..txt
--
select poc_insured_policy_id||chr(9)
||insured_fein||chr(9)
||insured_name||chr(9)
||insured_address_1||chr(9)
||insured_address_2||chr(9)
||insured_city||chr(9)
||insured_state||chr(9)
||insured_postal_code||chr(9)
||policy_number||chr(9)
||policy_effective_date||chr(9)
||policy_expiration_date||chr(9)
from c5;
--
spool off;
Works in SQL-Plus though
