Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Insert ' into a Oracle DB

Insert ' into a Oracle DB

From: Kyriakos Lambros <kyriakos.lambros_at_lvvwd.com>
Date: Thu, 09 Mar 2000 21:03:41 GMT
Message-ID: <38C8119D.CFEED67C@lvvwd.com>


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:03:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US