30, 'SALES', 'LIVERPOOL');
INSERT INTO DEPT2019274072 ( DEPTNO, DNAME, LOC ) VALUES (
40, 'OPERATIONS', 'STAFFORD');
INSERT INTO DEPT2019274072 ( DEPTNO, DNAME, LOC ) VALUES (
50, 'MARKETING', 'LUTON');
commit; -- 事务提交执行
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7369, 'SMITH', 'CLERK', 7902, '1990-12-17'
, 13750, NULL, 20);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7499, 'ALLEN', 'SALESMAN', 7698, '1989-02-20'
, 19000, 6400, 30);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7521, 'WARD', 'SALESMAN', 7698, '1993-02-22'
, 18500, 4250, 30);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7566, 'JONES', 'MANAGER', 7839, '1989-04-02'
, 26850, NULL, 20);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7654, 'MARTIN', 'SALESMAN', 7698, '1997-09-28'
, 15675, 3500, 30);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7698, 'BLAKE', 'MANAGER', 7839, '1990-05-01'
, 24000, NULL, 30);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (
7782, 'CLARK', 'MANAGER', 7839, '1988-06-09'
, 27500, NULL, 10);
INSERT INTO EMP2019274072 ( EMPNO, ENAME, JOB, MGR, HIREDATE, SAL,
COMM,
DEPTNO ) VALUES (