Return to Question

When I take a dump of a particular table which has CLOB data type, the resulting dump doesn't handle escaping of special characters.

I get ' un escaped, so insert statements won't work.

Any ways to fix it?

I'm right clicking on the query result and getting the dump.

I'm using SQL Developer.

When I take a dump of a particular table which has CLOB data type, the resulting dump doesn't handle escaping of special characters.

I get ' un escaped, so insert statements won't work.

Any ways to fix it?

I'm right clicking on the query result and getting the dump.

I'm using SQL Developer and am new to Oracle.

I'm new to oracle and I have this problem.

When I take a dump of particular table which has CLOB data type, the resulting dump doesnt handle escaping special characters.

So I get ' un escaped, so insert statements wont work.

Any ways to solve it  ?

I'm right clicking on the query result and getting the dump.

I'm using SQL Developer.

When I take a dump of a particular table which has CLOB data type, the resulting dump doesn't handle escaping of special characters.

I get ' un escaped, so insert statements won't work.

Any ways to fix it?

I'm right clicking on the query result and getting the dump.

I'm using SQL Developer.

I'm new to oracle and I have this problem.

When I take a dump of particular table which has CLOB data type, the resulting dump doesnt handle escaping special characters.

So I get ' un escaped, so insert statements wont work.

Any ways to solve it ?

I'm right clicking on the query result and getting the dump.

I'm new to oracle and I have this problem.

When I take a dump of particular table which has CLOB data type, the resulting dump doesnt handle escaping special characters.

So I get ' un escaped, so insert statements wont work.

Any ways to solve it ?

I'm right clicking on the query result and getting the dump.

I'm using SQL Developer.