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