Single Quote '

To insert or select single quote you can use chr(39). For example;

SQL> select chr(39) from dual;
'

SQL> CREATE TABLE MYTABLE (F1 VARCHAR2(100));

Table created.

SQL> insert into MYTABLE values('Orange Cote D'||chr(39)||' Ivoire S.A.');

1 row created.

SQL> select * from MYTABLE;
Orange Cote D' Ivoire S.A.

SQL>