Oracle special caracter '

From: Ramdane MAHIOU <ramdane.mahiou_at_cstelecom.cie-signaux.fr>
Date: Wed, 03 Mar 1999 16:53:29 +0100
Message-ID: <36DD5AF9.D34E32F4@cstelecom.cie-signaux.fr>

Hi! I'm trying to execute the following request:  insert into sites(num_site,nom_site)
values ( 1039872 , 'VILLENAVE D'ORNON(MSC)' )

I get the following error:
 insert into sites(num_site,nom_site)
values ( 1039872 , 'VILLENAVE D'ORNON(MSC)' )

                                                       *

ORA-00917: missing comma

I know the problem is the ' in the string but I don't know how to correct this
mistake. I need a help...

Thanks!

Ram Received on Wed Mar 03 1999 - 09:53:29 CST