Re: Oracle special caracter '

From: Mungo Henning <mungoh_at_itacs.strath.ac.uk>
Date: Thu, 04 Mar 1999 15:42:22 +0000
Message-ID: <36DEA9DE.13C0A482@itacs.strath.ac.uk>

Arjan van Bentem wrote:
>
> Ramdane MAHIOU wrote
> >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)' )

The solution is correct, but the "As in almost every programming language" is only correct if you have (say) a knowledge of two languages :-( Other languages use an escape character (such as in C and C++) or ban the use of a string terminator inside the string totally.

Otherwise in agreement with Arjan

Mungo Henning Received on Thu Mar 04 1999 - 09:42:22 CST