3 Replies Latest reply on Mar 18, 2009 12:42 PM by BluShadow

    ORA-01756: quoted string not properly terminated

    655578
      Hi,

      I am trying this sql statement:

      INSERT INTO orders (Order_Id,short_description,description) VALUES(1122, 'P29384', '50% Off Playin'TV For 1st 3 Mths');

      I hit this error:

      ORA-01756: quoted string not properly terminated

      I know it is because there is already a quoted string inside the text i am trying to insert. However, how do I insert into my table with this ' ?