How to spool oracle table records with control A character as delimiter through sql script in linux?
I have tried as below
Spool file.dat
Select column 1 ||'\u0001'||,
column2 ||'\u0001'||,
column3 from table
spool off
Also as
Spool file.dat
Select column 1 ||'^A'||,
column2 ||'^A'||,
column3 from table
spool off
But delimiter is coming as a string literal, How can this be done??
Thanks in advance.
