test221013

Tables (3)

dept

  • deptno — number(2,0)
  • dname — varchar2(14)
  • loc — varchar2(13)

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)

salgrade

  • grade — NUMBER
  • losal — NUMBER
  • hisal — NUMBER