문돌이 존버/DB 및 SQL 스터디
2021. 2. 27.
SQLD ROWNUM, LIKE, UNION, INTERSECT, MINUS 예제
예제 테이블 및 데이터 insertion CREATE TABLE emp ( empno NUMBER(4)NOT NULL, ename VARCHAR2(10), job VARCHAR2(9), mgr NUMBER(4), hiredate DATE, sal NUMBER(7,2), comm NUMBER(7,2), deptno NUMBER(2) ); ALTER TABLE emp ADD CONSTRAINT emp_pk PRIMARY KEY (empno); INSERT INTO emp VALUES(7839, 'KING', 'PRESIDENT', NULL, TO_DATE('1981-11-17', 'yyyy-mm-dd'), 5000, NULL, 10); INSERT INTO emp VALUES(7698, 'BLAKE', 'M..
