Oracle Live SQL - Script: SQL1

Statement 1

CREATE TABLE EMPLOYEE ( 
    EmpCode Number (8,0), 
    EmpFName VARCHAR(15), 
    EmpLName VARCHAR(15), 
    Job VARCHAR(45), 
    PhoneNo Number (10,0), 
    HireDate DATE, 
    Salary Number (10,3), 
    Commission Number (10,0), 
    DEPTCODE Number (10,0) 
)

Table created.

Statement 2

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9369, 'TONY', 'STARK', 'SOFTWARE ENGINEER', 7902 , DATE '1980-12-17' , 2800,0,20)

1 row(s) inserted.

Statement 3

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9499, 'TIM', 'ADOLF', 'SALESMAN', 7698, DATE '1981-02-20', 1600, 300,30)

1 row(s) inserted.

Statement 4

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9566, 'KIM', 'JARVIS', 'MANAGER', 7839, DATE '1981-04-02', 3570,0,20)

1 row(s) inserted.

Statement 5

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9654, 'SAM', 'MILES', 'SALESMAN', 7698, DATE '1981-09-28', 1250, 1400, 30)

1 row(s) inserted.

Statement 6

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9782, 'KEVIN', 'HILL', 'MANAGER', 7839, DATE '1981-06-09', 2940,0,10)

1 row(s) inserted.

Statement 7

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9788, 'CONNIE', 'SMITH', 'ANALYST', 7566, DATE '1982-12-09', 3000,0,20)

1 row(s) inserted.

Statement 8

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9839, 'ALFRED', 'KINSLEY', 'PRESIDENT', 7566, DATE '1981-11-17', 5000,0, 10)

1 row(s) inserted.

Statement 9

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9844, 'PAUL', 'TIMOTHY', 'SALESMAN', 7698, DATE '1981-09-08', 1500,0,30)

1 row(s) inserted.

Statement 10

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9876, 'JOHN', 'ASGHAR', 'SOFTWARE ENGINEER', 7788, DATE '1983-01-12',3100,0,20)

1 row(s) inserted.

Statement 11

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9900, 'ROSE', 'SUMMERS', 'TECHNICAL LEAD', 7698, DATE '1981-12-03', 2950,0, 20)

1 row(s) inserted.

Statement 12

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9902, 'ANDREW', 'FAULKNER', 'ANAYLYST', 7566, DATE '1981-12-03', 3000,0, 10)

1 row(s) inserted.

Statement 13

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9934, 'KAREN', 'MATTHEWS', 'SOFTWARE ENGINEER', 7782, DATE '1982-01-23', 3300,0,20)

1 row(s) inserted.

Statement 14

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9591, 'WENDY', 'SHAWN', 'SALESMAN', 7698, DATE '1981-02-22', 500,0,30)

1 row(s) inserted.

Statement 15

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9698, 'BELLA', 'SWAN', 'MANAGER', 7839, DATE '1981-05-01', 3420, 0,30)

1 row(s) inserted.

Statement 16

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9777, 'MADII', 'HIMBURY', 'ANALYST', 7839, DATE '1981-05-01', 2000, 200, NULL)

1 row(s) inserted.

Statement 17

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9860, 'ATHENA', 'WILSON', 'ANALYST', 7839, DATE '1992-06-21', 7000, 100, 50)

1 row(s) inserted.

Statement 18

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9861, 'JENNIFER', 'HUETTE', 'ANALYST', 7839, DATE '1996-07-01', 5000, 100, 50)

1 row(s) inserted.

Statement 19

delete from EMPLOYEE

17 row(s) deleted.

Statement 20

select *from EMPLOYEE

no data found

Statement 21

CREATE TABLE EMPLOYEE ( 
    EmpCode Number (8,0), 
    EmpFName VARCHAR(15), 
    EmpLName VARCHAR(15), 
    Job VARCHAR(45), 
    PhoneNo Number (10,0), 
    HireDate DATE, 
    Salary Number (10,3), 
    Commission Number (10,0), 
    DEPTCODE Number (10,0) 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 22

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9369, 'TONY', 'STARK', 'SOFTWARE ENGINEER', 7902 , DATE '1980-12-17' , 2800,0,20)

1 row(s) inserted.

Statement 23

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9499, 'TIM', 'ADOLF', 'SALESMAN', 7698, DATE '1981-02-20', 1600, 300,30)

1 row(s) inserted.

Statement 24

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9566, 'KIM', 'JARVIS', 'MANAGER', 7839, DATE '1981-04-02', 3570,0,20)

1 row(s) inserted.

Statement 25

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9654, 'SAM', 'MILES', 'SALESMAN', 7698, DATE '1981-09-28', 1250, 1400, 30)

1 row(s) inserted.

Statement 26

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9782, 'KEVIN', 'HILL', 'MANAGER', 7839, DATE '1981-06-09', 2940,0,10)

1 row(s) inserted.

Statement 27

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9788, 'CONNIE', 'SMITH', 'ANALYST', 7566, DATE '1982-12-09', 3000,0,20)

1 row(s) inserted.

Statement 28

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9839, 'ALFRED', 'KINSLEY', 'PRESIDENT', 7566, DATE '1981-11-17', 5000,0, 10)

1 row(s) inserted.

Statement 29

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9844, 'PAUL', 'TIMOTHY', 'SALESMAN', 7698, DATE '1981-09-08', 1500,0,30)

1 row(s) inserted.

Statement 30

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9876, 'JOHN', 'ASGHAR', 'SOFTWARE ENGINEER', 7788, DATE '1983-01-12',3100,0,20)

1 row(s) inserted.

Statement 31

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9900, 'ROSE', 'SUMMERS', 'TECHNICAL LEAD', 7698, DATE '1981-12-03', 2950,0, 20)

1 row(s) inserted.

Statement 32

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9902, 'ANDREW', 'FAULKNER', 'ANAYLYST', 7566, DATE '1981-12-03', 3000,0, 10)

1 row(s) inserted.

Statement 33

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9934, 'KAREN', 'MATTHEWS', 'SOFTWARE ENGINEER', 7782, DATE '1982-01-23', 3300,0,20)

1 row(s) inserted.

Statement 34

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9591, 'WENDY', 'SHAWN', 'SALESMAN', 7698, DATE '1981-02-22', 500,0,30)

1 row(s) inserted.

Statement 35

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9698, 'BELLA', 'SWAN', 'MANAGER', 7839, DATE '1981-05-01', 3420, 0,30)

1 row(s) inserted.

Statement 36

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9777, 'MADII', 'HIMBURY', 'ANALYST', 7839, DATE '1981-05-01', 2000, 200, NULL)

1 row(s) inserted.

Statement 37

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9860, 'ATHENA', 'WILSON', 'ANALYST', 7839, DATE '1992-06-21', 7000, 100, 50)

1 row(s) inserted.

Statement 38

insert into EMPLOYEE (EmpCode , EmpFName , EmpLName , Job , PhoneNo , HireDate , Salary , Commission , DEPTCODE) values (9861, 'JENNIFER', 'HUETTE', 'ANALYST', 7839, DATE '1996-07-01', 5000, 100, 50)

1 row(s) inserted.

Statement 39

delete from EMPLOYEE where EmpCode = 9698

1 row(s) deleted.

Statement 40

select *from EMPLOYEE


EMPCODE EMPFNAME EMPLNAME JOB PHONENO HIREDATE SALARY COMMISSION DEPTCODE
9369 TONY STARK SOFTWARE ENGINEER 7902 17-DEC-80 2800 0 20
9499 TIM ADOLF SALESMAN 7698 20-FEB-81 1600 300 30
9566 KIM JARVIS MANAGER 7839 02-APR-81 3570 0 20
9654 SAM MILES SALESMAN 7698 28-SEP-81 1250 1400 30
9782 KEVIN HILL MANAGER 7839 09-JUN-81 2940 0 10
9788 CONNIE SMITH ANALYST 7566 09-DEC-82 3000 0 20
9839 ALFRED KINSLEY PRESIDENT 7566 17-NOV-81 5000 0 10
9844 PAUL TIMOTHY SALESMAN 7698 08-SEP-81 1500 0 30
9876 JOHN ASGHAR SOFTWARE ENGINEER 7788 12-JAN-83 3100 0 20
9900 ROSE SUMMERS TECHNICAL LEAD 7698 03-DEC-81 2950 0 20
9902 ANDREW FAULKNER ANAYLYST 7566 03-DEC-81 3000 0 10
9934 KAREN MATTHEWS SOFTWARE ENGINEER 7782 23-JAN-82 3300 0 20
9591 WENDY SHAWN SALESMAN 7698 22-FEB-81 500 0 30
9777 MADII HIMBURY ANALYST 7839 01-MAY-81 2000 200  - 
9860 ATHENA WILSON ANALYST 7839 21-JUN-92 7000 100 50
9861 JENNIFER HUETTE ANALYST 7839 01-JUL-96 5000 100 50

16 rows selected.

EMPCODE	EMPFNAME	EMPLNAME	JOB	PHONENO	HIREDATE	SALARY	COMMISSION	DEPTCODE
9369	TONY	STARK	SOFTWARE ENGINEER	7902	17-DEC-80	2800	0	20
9499	TIM	ADOLF	SALESMAN	7698	20-FEB-81	1600	300	30
9566	KIM	JARVIS	MANAGER	7839	02-APR-81	3570	0	20
9654	SAM	MILES	SALESMAN	7698	28-SEP-81	1250	1400	30
9782	KEVIN	HILL	MANAGER	7839	09-JUN-81	2940	0	10
9788	CONNIE	SMITH	ANALYST	7566	09-DEC-82	3000	0	20
9839	ALFRED	KINSLEY	PRESIDENT	7566	17-NOV-81	5000	0	10
9844	PAUL	TIMOTHY	SALESMAN	7698	08-SEP-81	1500	0	30
9876	JOHN	ASGHAR	SOFTWARE ENGINEER	7788	12-JAN-83	3100	0	20
9900	ROSE	SUMMERS	TECHNICAL LEAD	7698	03-DEC-81	2950	0	20
9902	ANDREW	FAULKNER	ANAYLYST	7566	03-DEC-81	3000	0	10
9934	KAREN	MATTHEWS	SOFTWARE ENGINEER	7782	23-JAN-82	3300	0	20
9591	WENDY	SHAWN	SALESMAN	7698	22-FEB-81	500	0	30
9777	MADII	HIMBURY	ANALYST	7839	01-MAY-81	2000	200	-
9860	ATHENA	WILSON	ANALYST	7839	21-JUN-92	7000	100	50
9861	JENNIFER	HUETTE	ANALYST	7839	01-JUL-96	5000	100	50

SQL1

Additional Information