2009. 4. 14. 10:17

[Oracle] 테이블 복사

SELECT한 내용을 INSERT 하기

 

INSERT INTO CODELIBRARY3 (ID,TYPE,PARENT_ID,NAME,USE_YN,DEL_YN,FLAG) 
SELECT * FROM CODELIBRARY T1

 

테이블 복사

 

COPY FROM scott/tiger@oracle CREATE emp2 USING select * FROM emp;


CREATE TABLE emp2    AS    SELECT * FROM scott.emp;