Creating New Tables from existing table | Copy all columns and all data into new table
Creating New Tables in Oracle Using the CREATE TABLE AS SELECT (CTAS)
How to create a new table from the existing table.
1. Copy All Columns and Data
2. Copy Specific Columns and Data
3. Copy Structure Only (No Data)
4. Create Table with a Subset of Data
create table account2 as select * from account1;
create table account3 as select acc_no,balance,loan_taken from account1;
create table account4 as select acc_no as account_no, balance as bal,loan_taken as lt from account1;
create table account5 as select * from account1 where 0=1;
create table account6 as select * from account1 where balance=7000;
create table account7(a,b,c,d,e,f) as select *from account1;