[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 into a sql file that I can then load with sqlplus. That data contains characters special to sqlplus such as &.
I'm using the following to do the export:
@export set filename="/tmp/${dbvis-object}$.sql" format="sql";
It would be nice if there was a way you could specify both an escape character (such as '\') and a list of characters that should be escaped (such as both & and ;)
Maybe parameters on @export?
1 Comment
Roger Bjärevall
said
almost 11 years ago
[This reply is migrated from our old forums.]
Re: Escape characters in data in sql export
Jason,
I will register a ticket for for this request.
Regards
Roger
anonymous