Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Table

 

Create a copy table and aggregate function

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> drop table lookup_heap; Table dropped. SQL>