Re: VARCHAR variable in where clause
From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 20 Nov 2003 10:59:09 -0800
Message-ID: <4b5394b2.0311201059.2f1f5295_at_posting.google.com>
Date: 20 Nov 2003 10:59:09 -0800
Message-ID: <4b5394b2.0311201059.2f1f5295_at_posting.google.com>
"Peter Jenny" <Peter.Jenny_at_cedes.com> wrote in message news:<bpijac$4cc$1_at_rex.ip-plus.net>...
> Hi NG
>
> How do I have to use a VARCHAR2 variable in a where clause.
> I could not find an example.
>
> PART NR VARCHAR2(20);
> myPartId NUMBER()20;
>
> PART NR := '101 189';
> select part id into myPartId from part where part nr = PART NR; -- not
> working, hwo to do ?
>
> How do I have to "escape" the PART NR, that it will be:
>
> where part nr = '101 189'
>
> Thanks
> Peter
>
> --
What makes you think that
PART NR
is a valid variable name?
(HINT: try PART_NR) Received on Thu Nov 20 2003 - 19:59:09 CET