Oralce培训笔记-上课所用表结构

上课所用表结构：
desc emp:
Name     Type         Nullable Default Comments
-------- ------------ -------- ------- --------
EMPNO    NUMBER(4)                             
ENAME    VARCHAR2(10) Y                        
JOB      VARCHAR2(9)  Y                        
MGR      NUMBER(4)    Y                        
HIREDATE DATE         Y                        
SAL      NUMBER(7,2)  Y                        
COMM     NUMBER(7,2)  Y                        
DEPTNO   NUMBER(2)    Y  
 
desc dept:
Name   Type         Nullable Default Comments
------ ------------ -------- ------- --------
DEPTNO NUMBER(2)                             
DNAME  VARCHAR2(14) Y                        
LOC    VARCHAR2(13) Y  

desc salgrade:
Name  Type   Nullable Default Comments
----- ------ -------- ------- --------
GRADE NUMBER Y                        
LOSAL NUMBER Y                        
HISAL NUMBER Y 

desc bonus:
Name  Type         Nullable Default Comments
----- ------------ -------- ------- --------
ENAME VARCHAR2(10) Y                        
JOB   VARCHAR2(9)  Y                        
SAL   NUMBER       Y                        
COMM  NUMBER       Y