CREATE PROCEDURE P_TEST1
IS
V_SQL VARCHAR2(1000);
BEGIN
v_sql := 'CREATE TABLE P_TEST1_TABLE(P_ID NUMBER)';
EXECUTE IMMEDIATE v_sql;
FOR i IN 1..100 LOOP
v_sql := 'INSERT INTO P_TEST1_TABLE VALUES('||i||')';
EXECUTE IMMEDIATE v_sql;
END LOOP;
END P_TEST1;
过程名 P_TEST1
表名 P_TEST1_TABLE