How To Create a Table within a Procedure

Firt Create the Procedure

CREATE OR REPLACE PROCEDURE test_table
IS
BEGIN
   EXECUTE IMMEDIATE 'create table ttt_temp as select * from fnd_nodes';
END test_table;

Now Execute the procedure ...

EXEC test_table;

You Can Check the Table is created ...

SELECT *
  FROM ttt_temp;



--------------------------------------------------------------------------------