sample

Tables (3)

Copy Of dept (dept2)

  • deptno (번호)
  • dname (부서) — varchar2
  • loc (위치) — varchar

dept

  • deptno (Key) — Primary key — NOT NULL
  • dname (부서) — varchar2
  • loc (위치) — varchar

emp

  • empno (사번) — varchar2
  • ename (이름) — varchar2
  • sal (급여) — number
  • deptno (Key) — Foreign key → dept.deptno — NOT NULL