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.
Download the book in PDF, ePub, Kindle for a complete version.
create table test-Table-old as
( select * from test-Table-new)
where will the option to copy selected rows, specific columns instead of * restricting columns 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-1, col-5,