Re: how to use select clause in assignment
From: Frank <fbortel_at_nescape.net>
Date: Fri, 28 Nov 2003 09:08:41 +0100
Message-ID: <bq6vac$u1n$1_at_news3.tilbu1.nb.home.nl>
Date: Fri, 28 Nov 2003 09:08:41 +0100
Message-ID: <bq6vac$u1n$1_at_news3.tilbu1.nb.home.nl>
Christine wrote:
> like this,
>
> EXECUTE IMMEDIATE 'select empno from part where partid = '||part_id into myid;
Use BIND variables:
EXECUTE IMMEDIATE 'select empno from part where partid = :a'
using part_id
into myid;
-- Regards, Frank van BortelReceived on Fri Nov 28 2003 - 09:08:41 CET