11 Replies Latest reply: May 6, 2013 6:57 AM by 1007292 RSS

    Problem with single quote when exporting insert statement


      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?