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

→ Test-col2

against remove column

→ NEXT FINISH

10.05 How to create another table with the same set of column and data?

COPY table test-table-new to test-table-old

Through obJect Browser

Through sql command

Window

→ Tables

→ TEST-TABLE-NEW

→COPY

→ test-table-old in new table name

→ select all columns in

columns

→ select all rows against display

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