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.

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,

 

Find Your Next Great Read

Describe what you're looking for in as much detail as you'd like.
Our AI reads your request and finds the best matching books for you.

Showing results for ""

Popular searches:

Romance Mystery & Thriller Self-Help Sci-Fi Business