Re: pl/sql and hochkommas

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 07 Dec 2003 15:44:38 -0800
Message-ID: <GXOAb.70029$kl6.38294@fed1read03>

Hubert Holler wrote:

> "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
>
>

and buchstabe = upper( CHR(39) || varchar2_variable || CHR(39) ) Received on Sun Dec 07 2003 - 17:44:38 CST