Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle special caracter '
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