[This topic is migrated from our old forums. The original author name has been removed]
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?
1 Comment
Roger Bjärevall
said
almost 13 years ago
[This reply is migrated from our old forums.]
Re: Convert newlines in data in export to sql file
Jason,
Thanks for the suggestion. I will register a ticket for this.
Best Regards
Roger
anonymous