PL/SQL (MOSC)

MOSC Banner

How do I add a "line terminator" value to the PL/SQL function export_table_to_csv_file

in PL/SQL (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center