《MySQL数据库》之练习表数据：emp表与dept表的脚本整理

一、Oracle版本

1、dept表

drop table dept;
CREATE TABLE dept(
    deptno NUMBER(2),
    dname VARCHAR2(14) ,
    loc VARCHAR2(13) 
) ;

INSERT INTO dept VALUES(10,'ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES(20,'RESEARCH','DALLAS');
INSERT INTO dept VALUES(30,'SALES','CHICAGO');
INSERT INTO dept VALUES(40,'OPERATIONS','BOSTON');

2、emp表

drop table emp;
CREATE TABLE emp(
    empno NUMBER(4),
    ename VARCHAR2(10),
    job VARCHAR2(9),
    mgr NUMBER(4),
    hiredate DATE,
    sal NUMBER(7,2),
    comm NUMBER(7,2)，
    deptno NUMBER(2)
);

INSERT INTO emp VALUES(7369,'SMITH','CLERK',7902,to_date('17-12-1980','