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 -> Re: Oracle special caracter '

Re: Oracle special caracter '

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 3 Mar 1999 17:13:21 +0100
Message-ID: <36dd5fa8$0$27619@newton>


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. Received on Wed Mar 03 1999 - 10:13:21 CST

Original text of this message

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