1. Create
Create table emp
(Empno number (4) constraint EMP_pk primary key,
Ename varchar2 (9 ),
Job varchar2 (9 ),
Mgr number (4 ),
Hiredate date,
Sal number (7,2 ),
Comm number (7, 2 ),
Deptno number (2) constraint EMP_PK_DEPTNO references DEPT (deptno)
);
2. Insert
Insert into emp (empno, ename, job, mgr, hiredate, sal, deptno) values (7369, 'Smith ', 'cler', 7902, '17-DEC-80 ', );
Insert into emp (empno, ename, job, mgr, hiredate, sal, COMM, deptno) values (7499, 'allen ', 'salseman', 7698, '20-FEB-81 ', 1600,300, 30 );
Insert into emp (empno, ename, job, mgr, hiredate, sal, COMM, deptno) values (7521, 'ward ', 'salseman', 7698, '22-FEB-81 ', 1250,500, 30 );
Insert into emp (empno, ename, job, mgr, hiredate, sal, deptno) values (7566, 'Jones ', 'manager', 7839, '02-APR-81 ', 2975,20 );
Insert into emp (empno, ename, job, mgr, hiredate, sal, COMM, deptno) values (7645, 'martin ', 'salesman', 7698, '28-SEP-81 ', 1250,1400, 20 );
Insert into emp (empno, ename, job, mgr, hiredate, sal, deptno) values (7698, 'black', 'manager', 7839, '01-MAY-81 ', 2850,20 );
Insert into emp (empno, ename, job, mgr, hiredate, sal, COMM, deptno) values (7844, 'urner', 'salesman', 7698, '08-SEP-81 ', 1500,0, 20 );
From: column of huzia of China Coal Group