VARCHAR variable in where clause
From: Peter Jenny <Peter.Jenny_at_cedes.com>
Date: Thu, 20 Nov 2003 15:31:29 +0100
Message-ID: <bpijac$4cc$1_at_rex.ip-plus.net>
Date: Thu, 20 Nov 2003 15:31:29 +0100
Message-ID: <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
--Received on Thu Nov 20 2003 - 15:31:29 CET