Apostrophe / Single Quote

Tested on an Oracle 11 database. If you want to include an apostrophe in your data, you need to precede it with another apostrophe:

SQL> create table with_apostrophes

  2  (name varchar2(10))

  3  /

 

Table created.

 

SQL>

This does not work:

SQL> insert into with_apostrophes

  2  values ('O'Connor')

  3  /

ERROR:

ORA-01756: quoted string not properly terminated

 

SQL>

But this does:

SQL> insert into with_apostrophes

  2  values ('O''Donnell')

  3  /

 

1 row created.

 

SQL> select * from with_apostrophes

  2  /

 

NAME

----------

O'Donnell

 

SQL>