Re: How to use single quotes in a Oracle string ?

just double it:
SELECT
OST.INV_ITEM_ID
FROM
PS_N_PP_SCHED_TBL OST
WHERE
OST.N_ITEM_GRP_CD = 'AIT-3''5-5''25' "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 - 10:42:31 CEST