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;
Watch video Creating New Tables from existing table | Copy all columns and all data into new table online without registration, duration hours minute second in high quality. This video was added by user VCODE LOGIC 28 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 93 once and liked it 6 people.