How We Can Create A Table In Pl/sql Block. Insert Records Into It? Is It Possible By Some Procedure Or Function? Please Give Example?

How We Can Create A Table In Pl/sql Block. Insert Records Into It? Is

1.	How We Can Create A Table In Pl/sql Block. Insert Records Into It? Is It Possible By Some Procedure Or Function? Please Give Example?
Answer» Answer : CREATE OR REPLACE PROCEDURE ddl_create_proc (p_table_name IN VARCHAR2) AS l_stmt VARCHAR2(200); BEGIN DBMS_OUTPUT.put_line('STARTING '); l_stmt := 'create table '\|\| p_table_name \|\| ' as (SELECT * from emp )'; execute IMMEDIATE l_stmt; DBMS_OUTPUT.put_line('end '); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line ('exception '\|\|SQLERRM \|\| 'message'\|\|sqlcode); END;