Create Duplicate Oracle Table using SQL (Copy a Table) | Express Edition Tutorial | Learn SQL
Learn how to copy/clone/duplicate an Oracle table using SQL under 90 seconds!
Use the Oracle Express Edition for quick learning!
Clone an Oracle table using SQL!
-----------------------------------------------------------------------------------------------------------
How to create a duplicate table using SQL along with the data?
How to clone an Oracle table using SQL?
Here is the solution:
-----------------------------------------------------------------------------------------------------------
create table emp1copy1 as (select * from emp1);
-----------------------------------------------------------------------------------------------------------
Very Simple!
Here emp1 is the base table which is copied into the emp1copy1 table along with its rows.
The table emp1copy1 does not exist before this statement is run!
Download the latest Oracle Express Edition release here:
http://www.oracle.com/technetwork/dat...
Follow me on Instagram: / the_perfect_tutorials
Follow me on Facebook: / theperfecttutorials
On this page of the site you can watch the video online Create Duplicate Oracle Table using SQL (Copy a Table) | Express Edition Tutorial | Learn SQL with a duration of hours minute second in good quality, which was uploaded by the user The Perfect Tutorials 15 July 2018, share the link with friends and acquaintances, this video has already been watched 373 times on youtube and it was liked by 8 viewers. Enjoy your viewing!
