Use:
Accept tab_name prompt 'Enter table name: ';
Create table table_temp ......
Insert into table_temp as select (col1, col2...) from &tab_name;
-
Something like this will prompt the user to enter the table name from which to select the data and insert into another.