How to use single quotes in a Oracle string ?
From: Julien <Julien.Bellorgey_at_libertysurf.fr>
Date: Tue, 30 Jul 2002 10:42:49 +0200
Message-ID: <newscache$f7020h$s6d$1_at_news.tiscali.fr>
Date: Tue, 30 Jul 2002 10:42:49 +0200
Message-ID: <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:49 CEST