filmov
tv
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:
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:
0:03:52
0:06:08
0:04:28
0:03:43
0:07:15
0:05:09
0:05:13
0:02:19
0:17:07
0:17:27
0:00:52
0:30:45
0:09:26
0:04:59
0:25:37
0:23:58
0:26:00
0:06:12
0:04:22
0:06:02
0:23:05
0:05:09
0:09:14
0:20:35