Declare
Num number (12): = 0;
Begin
Begin
Execute Immediate
'Drop Table TB1';
EXCEPTION
WHEN
Others
THEN
NULL;
END;
Execute Immediate
'Create Table TB1 (
AA Number,
BB Number) ';
For Num in Select * from TB1 LOOP
INSERT INTO TB1 (AA, BB) VALUES (NUM, NUM);
End loop;
COMMIT;
END;
