Re: pl/sql and hochkommas

From: Hubert Holler <haiflosse_at_gmx.net>
Date: Sun, 7 Dec 2003 23:54:11 +0100
Message-ID: <3fd3ad49$0$17948$91cee783@newsreader01.highway.telekom.at>

"Ana C. Dent" <anacedent_at_hotmail.com> schrieb im Newsbeitrag news:MTNAb.70017$kl6.60060_at_fed1read03...
> Hubert Holler wrote:
> > I want to use a hochkomma in a select (insert) like:
> > select count(*) into v_vorhanden from wort_suche where wort_id =
v_id_wort
> > and buchstabe = upper( || "'" || buchstabe || "'" || ) and benutzer_id =
> > login.getid_benutzer;
> >
> > Hope there can somebody help me.
> > Thanks a lot.
> > Hubert
>
> I'm not 100% sure I understand what you are asking.
> You might want to use the CHR() function in place of single or double
> quote marks.
>

Can you give me an exampel how I can use chr() I think exactly chr(39) correctly in my select.

Thanks again.
Hubert Received on Sun Dec 07 2003 - 16:54:11 CST