Create a copy table and aggregate function : Copy Table « Table « Oracle PL/SQL Tutorial

SQL>
SQL> create table lookup_heap(
  2    key_col  primary key,
  3    key_val
  4  )as
  5  select object_name, max( owner||'_'||object_id )from all_objects group by object_name
  6  /

Table created.

SQL>
SQL>
SQL> drop table lookup_heap;

Table dropped.

SQL>

6.4.Copy Table
	6.4.1.	Create a copy table
	6.4.2.	Create table with primary key
	6.4.3.	Copy table with adding the primary key
	6.4.4.	Create a table by copy certain rows
	6.4.5.	Create a copy table and aggregate function
	6.4.6.	Create a copy by select specific columns
	6.4.7.	Copying table structure not data