JOIN의 종류
테이블 및 데이터 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748-- 예제 테이블 -- 1. 학과 테이블CREATE TABLE DEPARTMENT ( D_CODE VARCHAR2(10) NOT NULL, D_NAME CHAR(30) NOT NULL, CONSTRAINT PK_department PRIMARY KEY(D_CODE)); COMMENT ON TABLE DEPARTMENT IS '학과';COMMENT ON COLUMN DEPARTMENT.D_CODE IS '학과코드';COMMENT ON COLUMN DEPARTMENT.D_NAME IS '학과명'; -- 2. 성적등급 테이블CREATE T..
