Xref: alice comp.databases.oracle.misc:27031
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newspeer.monmouth.com!newsgate.cistron.nl!het.net!pascal.a2000.nl!newton.a2000.nl!not-for-mail
From: "Arjan van Bentem" <avbentem@DONT-YOU-DAREdds.nl>
Newsgroups: comp.databases.oracle.misc
References: <36DD5AF9.D34E32F4@cstelecom.cie-signaux.fr>
Subject: Re: Oracle special caracter '
Date: Wed, 3 Mar 1999 17:13:21 +0100
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Lines: 14
Message-ID: <36dd5fa8$0$27619@newton>
X-Trace: newton.a2000.nl 920477608 27619 62.108.6.40

Ramdane MAHIOU wrote
> insert into sites(num_site,nom_site)
>values ( 1039872 , 'VILLENAVE D'ORNON(MSC)' )
>                                                       *
>ORA-00917: missing comma


As in almost every programming language: just type the single quote twice:

    values (1039872 , 'VILLENAVE D''ORNON(MSC)' )

Arjan.