Re: pl/sql and hochkommas

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 07 Dec 2003 14:32:12 -0800
Message-ID: <MTNAb.70017$kl6.60060@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. Received on Sun Dec 07 2003 - 16:32:12 CST