Re: Dumb Question, how to insert ' into varchar2 field

From: Norman Dunbar <Norman_at_Dunbar-it.co.uk.REMOVETHIS>
Date: Tue, 15 Feb 2005 18:46:55 +0100
Message-ID: <cutfpv$of9$1$8300dec7@news.demon.co.uk>

Anurag Varma wrote:
> Norm,
>
> Yes you are correct. This behavior reminds me as being similar to how
> perl does the quoting.
>
> But to run some tests:
>
> ORA10.1> select q'{abcd ' efgh}' from dual;
>
> Q'{ABCD'EFGH}'
> ---------------------------------
> abcd ' efgh
>
> ORA10.1> select q'[abcd ' efgh]' from dual;
>
> Q'[ABCD'EFGH]'
> ---------------------------------
> abcd ' efgh
>

<SNIP>

Looks nice - thanks for doing the testing for me. Seems like they built in some nice delimiter handling.

Cheers,
Norm. Received on Tue Feb 15 2005 - 11:46:55 CST