Re: pl/sql and hochkommas

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 08 Dec 2003 17:21:30 -0800
Message-ID: <ps9Bb.77303$kl6.22398@fed1read03>

Hubert Holler wrote:
> "Mark C. Stock" <mcstockX_at_Xenquery .com> schrieb im Newsbeitrag
> news:fMidnXRtF6Uv-kmiRVn-jg_at_comcast.com...
>

>>"Hubert Holler" <haiflosse_at_gmx.net> wrote in message
>>news:3fd422d4$0$19008$91cee783_at_newsreader02.highway.telekom.at...
>>|
>>| > >
>>| > > 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.
>>| > >
>>|
>>| When I try:
>>| select count(*) into v_vorhanden from wort_suche where wort_id =

>
> v_id_wort
>

>>| and buchstabe = CHR(39) || upper(buchstabe) || CHR(39) and benutzer_id =
>>| login.getid_benutzer;
>>|
>>| it doesn't work but when I try:
>>|
>>| select count(*) into v_vorhanden from wort_suche where wort_id =

>
> v_id_wort
>

>>| and buchstabe = 'J' and benutzer_id = login.getid_benutzer;
>>|
>>| it does work.
>>|
>>| I hope someone can tell me the correct syntax for it.
>>|
>>| Thank a lot
>>|
>>| Hubert
>>|
>>|
>>|
>>
>>what do you mean by 'it doesn't work'? are you getting an error message?

>
> or
>

>>are you not getting the rows returned that you expect? as i mentioned in

>
> my
>

>>other post, your expression "buchstabe = CHR(39) || upper(buchstabe) ||
>>CHR(39)" will never evaluate to true -- is that the problem?
>>

>
> yes. What should I do now that it works.
> I will not get an error message.
>
> Hubert
>
>

The single quote marks are not required when the string to be matched is already inside of a VARCHAR2 variable.

and buchstabe = upper(buchstabe)
and benutzer_id = > | login.getid_benutzer; Received on Mon Dec 08 2003 - 19:21:30 CST