What is the procedure to create my own commercial?

WHAT IS THE SYNTAX TO CREATE A TEMP TABLE IN A PROCEDURE ? SQLPLUS?

• HELLO, I NEED TO CREATE A TEMPORARY TABLE AND INSERT VALUES INTO IT FROM ANOTHER TABLE , IN A STORED PROCEDURE.

• Answer:

  There are lots of ideas at http://oracledba.bigresource.com/PL-SQL-create-temporary-table-using-execute-immediate-LTBJxU3k0.html#koJ28oBHT but will show you one idea below where you create the temporary table via the data and structure of an existing table: CREATE OR REPLACE PROCEDURE temptablecreate (new_table_name VARCHAR2, old_table_name VARCHAR2) IS BEGIN CREATE GLOBAL TEMPORARY table new_table_name as (Select * from old_table_name); END; /