Re: How to use single quotes in a Oracle string ?
Date: Tue, 30 Jul 2002 09:59:54 -0400
Message-ID: <ai664q$drn0$1_at_news3.infoave.net>
OST.N_ITEM_GRP_CD = 'AIT-3||''''||5-5||''''||25' This is the easiest method I have worked with, just concatenate 4 single quotes where you want a single quote to appear.
"Julien" <Julien.Bellorgey_at_libertysurf.fr> wrote in message
news:newscache$f7020h$s6d$1_at_news.tiscali.fr...
> Hello,
>
> I have a problem with an SQL order which is generated dynamically from an
> SQR script.
> The SQR generates something like
> SELECT
> OST.INV_ITEM_ID
> FROM
> PS_N_PP_SCHED_TBL OST
> WHERE
> OST.N_ITEM_GRP_CD = 'AIT-3'5-5'25'
>
> which makes the script stopping with an error.
>
> I tried to replace single quotes by double quotes but it does not work and
> the solution of using " || chr(xxx) || " is pretty heavy to implement. Is
> there much easiest solution ?
> Thanks in advance
>
> Julien
>
>
Received on Tue Jul 30 2002 - 15:59:54 CEST