[DATABASE/ORACLE] 서브 쿼리를 이용해 테이블 생성하기

■ 서브 쿼리를 이용해 테이블을 생성하는 방법을 보여준다.

▶ 예제 코드 (SQL)


CREATE TABLE COMPUTER_STUDENT
(
    DEPT_ID
   ,YEAR
   ,STUDENT_ID
   ,NAME
   ,ID_NUMBER
   ,EMAIL
)
AS
SELECT
    DEPT_ID
   ,YEAR
   ,STUDENT_ID
   ,NAME
   ,ID_NUMBER
   ,EMAIL
FROM  STUDENT
WHERE DEPT_ID = '컴공';

CREATE TABLE COMPUTER_STUDENT

(

DEPT_ID

,YEAR

,STUDENT_ID

,NAME

,ID_NUMBER

,EMAIL

)

SELECT

DEPT_ID

,YEAR

,STUDENT_ID

,NAME

,ID_NUMBER

,EMAIL

FROM STUDENT

WHERE DEPT_ID = '컴공';