Oracle7 Server Utilities

Tables Used in the Case Studies

The case studies are based upon the standard Oracle demonstration database tables EMP and DEPT owned by SCOTT/TIGER. (In some of the case studies, additional columns have been added.)

Contents of 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))

Contents of Table DEPT

  (deptno         NUMBER(2) NOT NULL,

   dname           VARCHAR2(14),

   loc             VARCHAR2(13))