Insert ' into a Oracle DB

Hi Andreas,

Each time you wish to insert the ', replace it with '' (two single quotes).

Example:

INSERT INTO table_name(column1)
VALUES ('I''m young, I''m new and I''m silly........');

Hope that helps,

Kyriakos Lambros
Programmer
Las Vegas Valley Water District Received on Thu Mar 09 2000 - 15:13:45 CST