How do I add a "line terminator" value to the PL/SQL function export_table_to_csv_file
I would like to export a table containing CLOB columsn to a delimited file per below specs
FIELDS TERMINATED BY '|^' LINES TERMINATED BY '#@%'
I am using the the PL/SQL function export_table_to_csv_file in Doc ID 1967617.1 and I am able to use '|^' as the field delimiter but I also need to have '#@%' at the end of each row as a record delimiter/line terminator.
Currently below usage gives '|^' as the field delimiter .. I just need to know how how to modify the code to add '#@%' at the end of each row as a record delimiter/line