SQL> CREATE OR REPLACE PROCEDURE prod_test IS 2 BEGIN 3 EXECUTE IMMEDIATE 'update t1 set t1.name=''yang'''; 4 END prod_test; 5 /Procedure createdSQL> exec prod_test;PL/SQL procedure successfully completedSQL> select * from t1; ID NAME ---------- ---------- 1 yangSQL> SQL> CREATE OR REPLACE PROCEDURE prod_test1 IS 2 BEGIN 3 EXECUTE IMMEDIATE 'update t1 set t1.name=''zhang'''; 4 END prod_test1; 5 /Procedure createdSQL> exec prod_test1;PL/SQL procedure successfully completedSQL> select * from t1; ID NAME ---------- ---------- 1 zhangSQL>
2 BEGIN
3 EXECUTE IMMEDIATE 'update t1 set t1.name=''yang''';
4 END prod_test;
5 /Procedure createdSQL> exec prod_test;PL/SQL procedure successfully completedSQL> select * from t1; ID NAME
---------- ----------
1 yangSQL>
SQL> CREATE OR REPLACE PROCEDURE prod_test1 IS
2 BEGIN
3 EXECUTE IMMEDIATE 'update t1 set t1.name=''zhang''';
4 END prod_test1;
5 /Procedure createdSQL> exec prod_test1;PL/SQL procedure successfully completedSQL> select * from t1; ID NAME
---------- ----------
1 zhangSQL>
sql_str := '
delete from '||occur_name||'
where partition_id = '||to_char(i)||'
' ;
execute immediate sql_str;update 语句也就类似而已哈..