データベースベース——データ準備

どんな技術も見たりしないではいられません。プログラミングは特にこのようです。次は2つの表を作成します。社員表と部門表（dept）を挿入して、次の勉強に使います。

--      emp
CREATE TABLE emp(
  empno NUMBER(4,0),
  ename VARCHAR2(10),
  job VARCHAR2(9),
  mgr NUMBER(4,0),
  hiredate DATE,
  sal NUMBER(7,2),
  comm NUMBER(7,2),
  deptno NUMBER(2,0)
);

--      dept
CREATE TABLE dept(
  deptno NUMBER(2,0),
  dname VARCHAR2(14 BYTE),
  loc VARCHAR2(13 BYTE)
);

--     
INSERT INTO emp VALUES(7369,'SMITH','CLERK',7902,
                       TO_DATE('1980-12-17','yyyy-mm-dd'),
                       800,NULL,20);
INSERT INTO emp VALUES(7499,'ALLEN','SALSESMAN',7698,
                       TO_DATE('1981-02-20','yyyy-mm-dd'),
                       1600,300,30);
INSERT INTO emp VALUES(7521,'WARD','SALSESMAN',7698,
                       TO_DATE('1981-02-22','yyyy-mm-dd'),
                       1250,500,30);
INSERT INTO emp VALUES(7566,'JONSE','MANAGER',7839,
                       TO_DATE('1981-04-02','yyyy-mm-dd'),
                       2975,NULL,20);
INSERT INTO emp VALUES(7654,'MARTIN','SALSESMAN',7698,
                       TO_DATE('1981-09-28','yyyy-mm-dd'),
                       1250,1400,30);
INSERT INTO emp VALUES(7698,'BLAKE','MANAGER',7839,
                       TO_DATE('1981-05-01','yyyy-mm-dd'),
                       2850,NULL,30);
INSERT INTO emp VALUES(7782,'CLARK','MANAGER',7839,
                       TO_DATE('1981-06-09','yyyy-mm-dd'),
                       2450,NULL,10);
INSERT INTO emp VALUES(7788,'SCOTT','ANALYST',7566,
                       TO_DATE('1987-04-19','yyyy-mm-dd'),
                       3000,NULL,50);
INSERT INTO emp VALUES(7839,'KING','PRESIDENT',NULL,
                       TO_DATE('1981-11-17','yyyy-mm-dd'),
                       5000,NULL,10);
INSERT INTO emp VALUES(7844,'TURNER','SALESMAN',7698,
                       TO_DATE('1981-09-08','yyyy-mm-dd'),
                       1500,0,30);
INSERT INTO emp VALUES(7876,'ADAMS','CLERK',7788,
                       TO_DATE('1987-05-23','yyyy-mm-dd'),
                       1100,NULL,20);       
INSERT INTO emp VALUES(7900,'JAMES','CLERK',7698,
                       TO_DATE('1981-12-03','yyyy-mm-dd'),
                       950,NULL,30);  
INSERT INTO emp VALUES(7902,'FORD','ANALYST',7566,
                       TO_DATE('1987-05-23','yyyy-mm-dd'),
                       3000,NULL,20);  
INSERT INTO emp VALUES(7934,'MILLER','CLERK',7782,
                       TO_DATE('1982-01-23','yyyy-mm-dd'),
                       1300,NULL,10);      

INSERT INTO dept VALUES(10,'ACCOUNTING','NEW YORK');  
INSERT INTO dept VALUES(20,'RESEARCH','DALLAS');
INSERT INTO dept VALUES(30,'SALSE','CHICAGO');
INSERT INTO dept VALUES(40,'OPERATIONS','BOSTON');

COMMIT;

SELECT * FROM emp;
SELECT * FROM dept;