SQL DEVELOPER TABLE 복제하기

CTAS;  
\--CREATE TABLE AS SELECTED--

CREATE TABLE EMP\_B  
AS SELECT \* FROM EMP;

SELECT \* FROM EMP\_B;

DELETE FROM EMP;

COMMIT;

INSERT INTO EMP SELECT \* FROM EMP\_B;

COMMIT;