Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

 

 

→ NEXT FINISH            Copy a table into another table ( with all columns, with all rows)

create table

 

<<table-name>> as select * from

<<to-be-copied file-name>>

copying selected columns from another table

 

create table

 

<<new_table_name>> as  ( select col_], col_5, col_2 from

<<old_table>>