Hi,
I would like to spool a file from a table in Oracle and use CTRL-Y as the colsep in my script:
set pagesize 0
set linesize 5000
set trimspool on
set wrap off
set colsep x'19'
set head off
set verify off
set feedback off
set termout off
alter session set nls_date_format = 'YYYYMMDD';
spool test.txt;
select * from <tablename>;
spool off;
Using sqlldr, I can load data from files separated by ^Y using x'19' :
FIELDS TERMINATED BY x'19'
Is this possible?