SCOTT
Tables (4)
BONUS
- ENAME — VARCHAR2(10)
- JOB — VARCHAR2(9)
- SAL — NUMBER
- COMM — NUMBER
DEPT
- DEPTNO — NUMBER(2,0) — Primary key — NOT NULL
- DNAME — VARCHAR2(14)
- LOC — VARCHAR2(13)
EMP
- EMPNO — NUMBER(4) — Primary key — NOT NULL
- ENAME — VARCHAR2(10)
- JOB — VARCHAR2(9)
- MGR — NUMBER(4,0)
- HIREDATE — DATE
- SAL — NUMBER(7,2)
- COMM — NUMBER(7,2)
- DEPTNO — NUMBER(2,0) — Foreign key → DEPT.DEPTNO — NOT NULL
SALGRADE
- GRADE — NUMBER
- LOSAL — NUMBER
- HISAL — NUMBER
- Field