Convert newlines in data in export to sql file

I'm trying to export a table with a VARCHAR(4000) field that contains newlines into a sql file that I can then load using a tool like sqlplus @export set filename="/tmp/${dbvis-object}$.sql" format="sql"; Even though the newlines are in a quoted field, sqlplus doesn't seem smart enough to handle. It would be nice if there was a way you could convert those newlines automatically to generate something like: insert into myTable ( myCol ) values ( 'first line of data' || chr(10) || 'second line of data' ) Maybe a parameter on @export?