Start a new topic

Escape characters in data in sql export

anonymous

started a topic almost 11 years ago

[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

How can we help you today?

Escape characters in data in sql export

anonymous

Roger Bjärevall