Sql>
Sql> CREATE TABLE EMP (empno number (4) is not NULL,
2 ename varchar2 (10),
3 Job Varchar2 (9),
4 Mgr Number (4),
5 HireDate Date,
6 Sal Number (7, 2),
7 Comm Number (7, 2),
8 Deptno Number (2));
Table created.
Sql>
sql> INSERT INTO EMP values (7369, ' Smith ', ' clerk ', 7902, to_date (' 17-dec-1980 ', ' dd-mon-yyyy '), 20;
1 row created.
sql> INSERT INTO EMP values (7499, ' Allen ', ' salesman ', 7698, to_date (' 20-feb-1981 ', ' dd-mon-yyyy '), 1600, 300, 30);
1 row created.
sql> INSERT INTO EMP values (7521, ' Ward ', ' salesman ', 7698, to_date (' 22-feb-1981 ', ' dd-mon-yyyy '), 1250, 500, 30);
1 row created.
sql> INSERT INTO EMP values (7566, ' Jones ', ' manager ', 7839, to_date (' 2-apr-1981 ', ' dd-mon-yyyy '), 2975, NULL, 20);
1 row created.
sql> INSERT INTO EMP values (7654, ' Martin ', ' salesman ', 7698,to_date (' 28-sep-1981 ', ' dd-mon-yyyy '), 1250, 1400, 30);
1 row created.
sql> INSERT INTO EMP values (7698, ' Blake ', ' manager ', 7839,to_date (' 1-may-1981 ', ' dd-mon-yyyy '), 2850, NULL, 30);
1 row created.
sql> INSERT INTO EMP values (7782, ' Clark ', ' manager ', 7839,to_date (' 9-jun-1981 ', ' dd-mon-yyyy '), 2450, NULL, 10);
1 row created.
sql> INSERT INTO EMP values (7788, ' Scott ', ' analyst ', 7566,to_date (' 09-dec-1982 ', ' dd-mon-yyyy '), 3000, NULL, 20);
1 row created.
sql> INSERT INTO EMP values (7839, ' king ', ' president ', null,to_date (' 17-nov-1981 ', ' dd-mon-yyyy '), 5000, NULL, 10);
1 row created.
sql> INSERT INTO EMP values (7844, ' Turner ', ' salesman ', 7698,to_date (' 8-sep-1981 ', ' dd-mon-yyyy '), 1500, 0, 30);
1 row created.
sql> INSERT INTO EMP values (7876, ' Adams ', ' Clerk ', 7788,to_date (' 12-jan-1983 ', ' dd-mon-yyyy '), 1100, NULL, 20);
1 row created.
sql> INSERT INTO EMP values (7900, ' James ', ' Clerk ', 7698,to_date (' 3-dec-1981 ', ' dd-mon-yyyy '), 950, NULL, 30);
1 row created.
sql> INSERT INTO EMP values (7902, ' Ford ', ' Analyst ', 7566,to_date (' 3-dec-1981 ', ' dd-mon-yyyy '), 3000, NULL, 20);
1 row created.
sql> INSERT INTO EMP values (7934, ' Miller ', ' clerk ', 7782,to_date (' 23-jan-1982 ', ' dd-mon-yyyy '), 1300, NULL, 10);
1 row created.
Sql>
Sql>
Sql> CREATE TABLE Emp_reg
2 AS
3 SELECT * from EMP;
Sql>
Sql> ALTER TABLE EMP_REG add constraint EMP_PK primary key (EMPNO);
Table Altered.
Sql>
Sql>
sql> drop table Emp_reg;
Table dropped.
Sql>--