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,