Re: Transfering Records To Another Table
From: <michael_bialik_at_my-deja.com>
Date: Thu, 22 Jul 1999 20:28:53 GMT
Message-ID: <7n7utm$4v8$1_at_nnrp1.deja.com>
END; It will work without a CURSOR and without BULK BINDs, but for UPDATE I would use a CURSOR.
Date: Thu, 22 Jul 1999 20:28:53 GMT
Message-ID: <7n7utm$4v8$1_at_nnrp1.deja.com>
Hi.
Here is another way to make an INSERTs :
CREATE OR REPLACE PROCEDURE copy_data ( parm1 IN VARCHAR2, parm2 IN NUMBER, ... , parmN IN VARCHAR2 ) IS BEGIN
INSERT INTO tab2 (f11,f12,f13,f14,f15,f16 ) SELECT f1,f2,f3,f4,f5,parm3 FROM tab1 WHERE fx = parm1 and fy = parm2; COMMIT;
END; It will work without a CURSOR and without BULK BINDs, but for UPDATE I would use a CURSOR.
Michael.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 22 1999 - 22:28:53 CEST