Re: PL/sql question
From: luio <lctNOlcSPAM_at_hotmail.com.invalid>
Date: 2000/08/03
Message-ID: <0f3431c0.21c48867_at_usw-ex0104-028.remarq.com>#1/1
Date: 2000/08/03
Message-ID: <0f3431c0.21c48867_at_usw-ex0104-028.remarq.com>#1/1
sorry, how to use DBMS_SQL.EXECUTE?
if insert into tb2 select x from tb2; is a practical code in
one of my big store procedure?
DBMS_SQL.EXECUTE and just supply the cursor ID that has been declared with the SQL string you specified below. For 7 look at the PARSE function.
BTW - your SQL is wrong... just do:
insert into tb2 select x from tb2;
Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
Received on Thu Aug 03 2000 - 00:00:00 CEST