This discussion is archived
11 Replies Latest reply: May 6, 2013 4:57 AM by 1007292 RSS

Problem with single quote when exporting insert statement

587440 Newbie
Currently Being Moderated

I'm using Oracle SQL Developer on Ubuntu 10.04. I got some records which has single quote in it.

For example,
Let says Table '*TABLE_A*' has varchar2 column called '*COL_A*'.
And there is only one record in the table and the value is:

his friend's dog name is dog.

When I export that table data to insert statement, i got this:

Insert into TABLE_A (COL_A) VALUES ('his friend's dog name is dog.');

As you can see friend's is wrong, it should be friend''s instead. (note the double single quotes).

Anyone knows how to fix this please?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points