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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
delete from EMPLOYEE
17 row(s) deleted.
select *from EMPLOYEE
no data found
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 objectMore Details: https://docs.oracle.com/error-help/db/ora-00955
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
delete from EMPLOYEE where EmpCode = 9698
1 row(s) deleted.
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 |
---|