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.
→ 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