Please note, this is a STATIC archive of website www.w3resource.com from 19 Jul 2022, cach3.com does not collect or store any user information, there is no "phishing" involved.
w3resource

Oracle SQL Query: Get the details of all employees and also display the specific information of all employees

Oracle SQL Query: Basic Exercise-1 with Solution

Write a Oracle SQL query to get the details of all employees and also display the specific information of all employees.

Sample Solution:

Oracle Code :

CREATE TABLE employees (
  EMPLOYEE_ID numeric(6) NOT NULL primary key,
  FIRST_NAME varchar2(20) DEFAULT NULL,
  LAST_NAME varchar2(25) NOT NULL,
  EMAIL varchar2(25) NOT NULL,
  PHONE_NUMBER varchar2(20) DEFAULT NULL,
  HIRE_DATE date NOT NULL,
  JOB_ID varchar2(10) NOT NULL,
  SALARY decimal(8,2) DEFAULT NULL,
  COMMISSION_PCT decimal(2,2) DEFAULT NULL,
  MANAGER_ID numeric(6) DEFAULT NULL,
  DEPARTMENT_ID numeric(4) DEFAULT NULL
);


INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (100,'Steven','King','SKING','515.123.4567','17-JUN-2003','AD_PRES',24000.00,0.00,0,90);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (101,'Neena','Kochhar','NKOCHHAR','515.123.4568','21-SEP-2005','AD_VP',17000.00,0.00,100,90);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (102,'Lex','De Haan','LDEHAAN','515.123.4569','13-JAN-2001','AD_VP',17000.00,0.00,100,90);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (103,'Alexander','Hunold','AHUNOLD','590.423.4567','03-JAN-2006','IT_PROG',9000.00,0.00,102,60);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (104,'Bruce','Ernst','BERNST','590.423.4568','21-MAY-2007','IT_PROG',6000.00,0.00,103,60);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (105,'David','Austin','DAUSTIN','590.423.4569','25-JUN-2005','IT_PROG',4800.00,0.00,103,60);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (106,'Valli','Pataballa','VPATABAL','590.423.4560','05-FEB-2006','IT_PROG',4800.00,0.00,103,60);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (107,'Diana','Lorentz','DLORENTZ','590.423.5567','07-FEB-2007','IT_PROG',4200.00,0.00,103,60);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (108,'Nancy','Greenberg','NGREENBE','515.124.4569','17-AUG-2002','FI_MGR',12000.00,0.00,101,100);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (109,'Daniel','Faviet','DFAVIET','515.124.4169','16-AUG-2002','FI_ACCOUNT',9000.00,0.00,108,100);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (110,'John','Chen','JCHEN','515.124.4269','28-SEP-2005','FI_ACCOUNT',8200.00,0.00,108,100);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (111,'Ismael','Sciarra','ISCIARRA','515.124.4369','30-SEP-2005','FI_ACCOUNT',7700.00,0.00,108,100);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (112,'Jose Manuel','Urman','JMURMAN','515.124.4469','07-MAR-2006','FI_ACCOUNT',7800.00,0.00,108,100);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (113,'Luis','Popp','LPOPP','515.124.4567','07-DEC-2007','FI_ACCOUNT',6900.00,0.00,108,100);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (114,'Den','Raphaely','DRAPHEAL','515.127.4561','07-DEC-2002','PU_MAN',11000.00,0.00,100,30);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (115,'Alexander','Khoo','AKHOO','515.127.4562','18-MAY-2003','PU_CLERK',3100.00,0.00,114,30);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (116,'Shelli','Baida','SBAIDA','515.127.4563','24-DEC-2005','PU_CLERK',2900.00,0.00,114,30);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (117,'Sigal','Tobias','STOBIAS','515.127.4564','24-JUL-2005','PU_CLERK',2800.00,0.00,114,30);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (118,'Guy','Himuro','GHIMURO','515.127.4565','15-NOV-2006','PU_CLERK',2600.00,0.00,114,30);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (119,'Karen','Colmenares','KCOLMENA','515.127.4566','10-AUG-2007','PU_CLERK',2500.00,0.00,114,30);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (120,'Matthew','Weiss','MWEISS','650.123.1234','18-JUL-2004','ST_MAN',8000.00,0.00,100,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (121,'Adam','Fripp','AFRIPP','650.123.2234','10-APR-2005','ST_MAN',8200.00,0.00,100,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (122,'Payam','Kaufling','PKAUFLIN','650.123.3234','01-MAY-2003','ST_MAN',7900.00,0.00,100,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (123,'Shanta','Vollman','SVOLLMAN','650.123.4234','10-OCT-2005','ST_MAN',6500.00,0.00,100,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (124,'Kevin','Mourgos','KMOURGOS','650.123.5234','16-NOV-2007','ST_MAN',5800.00,0.00,100,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (125,'Julia','Nayer','JNAYER','650.124.1214','16-JUL-2005','ST_CLERK',3200.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (126,'Irene','Mikkilineni','IMIKKILI','650.124.1224','28-SEP-2006','ST_CLERK',2700.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (127,'James','Landry','JLANDRY','650.124.1334','14-JAN-2007','ST_CLERK',2400.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (128,'Steven','Markle','SMARKLE','650.124.1434','08-MAR-2008','ST_CLERK',2200.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (129,'Laura','Bissot','LBISSOT','650.124.5234','20-AUG-2005','ST_CLERK',3300.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (130,'Mozhe','Atkinson','MATKINSO','650.124.6234','30-OCT-2005','ST_CLERK',2800.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (131,'James','Marlow','JAMRLOW','650.124.7234','16-FEB-2005','ST_CLERK',2500.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (132,'TJ','Olson','TJOLSON','650.124.8234','10-APR-2007','ST_CLERK',2100.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (133,'Jason','Mallin','JMALLIN','650.127.1934','14-JUN-2004','ST_CLERK',3300.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (134,'Michael','Rogers','MROGERS','650.127.1834','26-AUG-2006','ST_CLERK',2900.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (135,'Ki','Gee','KGEE','650.127.1734','12-DEC-2007','ST_CLERK',2400.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (136,'Hazel','Philtanker','HPHILTAN','650.127.1634','06-FEB-2008','ST_CLERK',2200.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (137,'Renske','Ladwig','RLADWIG','650.121.1234','14-JUL-2003','ST_CLERK',3600.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (138,'Stephen','Stiles','SSTILES','650.121.2034','26-OCT-2005','ST_CLERK',3200.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (139,'John','Seo','JSEO','650.121.2019','12-FEB-2006','ST_CLERK',2700.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (140,'Joshua','Patel','JPATEL','650.121.1834','06-APR-2006','ST_CLERK',2500.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (141,'Trenna','Rajs','TRAJS','650.121.8009','17-OCT-2003','ST_CLERK',3500.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (142,'Curtis','Davies','CDAVIES','650.121.2994','29-JAN-2005','ST_CLERK',3100.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (143,'Randall','Matos','RMATOS','650.121.2874','15-MAR-2006','ST_CLERK',2600.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (144,'Peter','Vargas','PVARGAS','650.121.2004','09-JUL-2006','ST_CLERK',2500.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (145,'John','Russell','JRUSSEL','011.44.1344.429268','01-JAN-2004','SA_MAN',14000.00,0.40,100,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (146,'Karen','Partners','KPARTNER','011.44.1344.467268','05-JAN-2005','SA_MAN',13500.00,0.30,100,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (147,'Alberto','Errazuriz','AERRAZUR','011.44.1344.429278','10-MAR-2005','SA_MAN',12000.00,0.30,100,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (148,'Gerald','Cambrault','GCAMBRAU','011.44.1344.619268','15-OCT-2007','SA_MAN',11000.00,0.30,100,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (149,'Eleni','Zlotkey','EZLOTKEY','011.44.1344.429018','29-JAN-2008','SA_MAN',10500.00,0.20,100,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (150,'Peter','Tucker','PTUCKER','011.44.1344.129268','30-JAN-2005','SA_REP',10000.00,0.30,145,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (151,'David','Bernstein','DBERNSTE','011.44.1344.345268','24-MAR-2005','SA_REP',9500.00,0.25,145,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (152,'Peter','Hall','PHALL','011.44.1344.478968','20-AUG-2005','SA_REP',9000.00,0.25,145,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (153,'Christopher','Olsen','COLSEN','011.44.1344.498718','30-MAR-2006','SA_REP',8000.00,0.20,145,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (154,'Nanette','Cambrault','NCAMBRAU','011.44.1344.987668','09-DEC-2006','SA_REP',7500.00,0.20,145,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (155,'Oliver','Tuvault','OTUVAULT','011.44.1344.486508','23-NOV-2007','SA_REP',7000.00,0.15,145,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (156,'Janette','King','JKING','011.44.1345.429268','30-JAN-2004','SA_REP',10000.00,0.35,146,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (157,'Patrick','Sully','PSULLY','011.44.1345.929268','04-MAR-2004','SA_REP',9500.00,0.35,146,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (158,'Allan','McEwen','AMCEWEN','011.44.1345.829268','01-AUG-2004','SA_REP',9000.00,0.35,146,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (159,'Lindsey','Smith','LSMITH','011.44.1345.729268','10-MAR-2005','SA_REP',8000.00,0.30,146,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (160,'Louise','Doran','LDORAN','011.44.1345.629268','15-DEC-2005','SA_REP',7500.00,0.30,146,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (161,'Sarath','Sewall','SSEWALL','011.44.1345.529268','03-NOV-2006','SA_REP',7000.00,0.25,146,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (162,'Clara','Vishney','CVISHNEY','011.44.1346.129268','11-NOV-2005','SA_REP',10500.00,0.25,147,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (163,'Danielle','Greene','DGREENE','011.44.1346.229268','19-MAR-2007','SA_REP',9500.00,0.15,147,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (164,'Mattea','Marvins','MMARVINS','011.44.1346.329268','24-JAN-2008','SA_REP',7200.00,0.10,147,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (165,'David','Lee','DLEE','011.44.1346.529268','23-FEB-2008','SA_REP',6800.00,0.10,147,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (166,'Sundar','Ande','SANDE','011.44.1346.629268','24-MAR-2008','SA_REP',6400.00,0.10,147,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (167,'Amit','Banda','ABANDA','011.44.1346.729268','21-APR-2008','SA_REP',6200.00,0.10,147,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (168,'Lisa','Ozer','LOZER','011.44.1343.929268','11-MAR-2005','SA_REP',11500.00,0.25,148,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (169,'Harrison','Bloom','HBLOOM','011.44.1343.829268','23-MAR-2006','SA_REP',10000.00,0.20,148,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (170,'Tayler','Fox','TFOX','011.44.1343.729268','24-JAN-2006','SA_REP',9600.00,0.20,148,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (171,'William','Smith','WSMITH','011.44.1343.629268','23-FEB-2007','SA_REP',7400.00,0.15,148,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (172,'Elizabeth','Bates','EBATES','011.44.1343.529268','24-MAR-2007','SA_REP',7300.00,0.15,148,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (173,'Sundita','Kumar','SKUMAR','011.44.1343.329268','21-APR-2008','SA_REP',6100.00,0.10,148,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (174,'Ellen','Abel','EABEL','011.44.1644.429267','11-MAY-2004','SA_REP',11000.00,0.30,149,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (175,'Alyssa','Hutton','AHUTTON','011.44.1644.429266','19-MAR-2005','SA_REP',8800.00,0.25,149,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (176,'Jonathon','Taylor','JTAYLOR','011.44.1644.429265','24-MAR-2006','SA_REP',8600.00,0.20,149,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (177,'Jack','Livingston','JLIVINGS','011.44.1644.429264','23-APR-2006','SA_REP',8400.00,0.20,149,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (178,'Kimberely','Grant','KGRANT','011.44.1644.429263','24-MAY-2007','SA_REP',7000.00,0.15,149,0);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (179,'Charles','Johnson','CJOHNSON','011.44.1644.429262','04-JAN-2008','SA_REP',6200.00,0.10,149,80);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (180,'Winston','Taylor','WTAYLOR','650.507.9876','24-JAN-2006','SH_CLERK',3200.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (181,'Jean','Fleaur','JFLEAUR','650.507.9877','23-FEB-2006','SH_CLERK',3100.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (182,'Martha','Sullivan','MSULLIVA','650.507.9878','21-JUN-2007','SH_CLERK',2500.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (183,'Girard','Geoni','GGEONI','650.507.9879','03-FEB-2008','SH_CLERK',2800.00,0.00,120,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (184,'Nandita','Sarchand','NSARCHAN','650.509.1876','27-JAN-2004','SH_CLERK',4200.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (185,'Alexis','Bull','ABULL','650.509.2876','20-FEB-2005','SH_CLERK',4100.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (186,'Julia','Dellinger','JDELLING','650.509.3876','24-JUN-2006','SH_CLERK',3400.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (187,'Anthony','Cabrio','ACABRIO','650.509.4876','07-FEB-2007','SH_CLERK',3000.00,0.00,121,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (188,'Kelly','Chung','KCHUNG','650.505.1876','14-JUN-2005','SH_CLERK',3800.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (189,'Jennifer','Dilly','JDILLY','650.505.2876','13-AUG-2005','SH_CLERK',3600.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (190,'Timothy','Gates','TGATES','650.505.3876','11-JUL-2006','SH_CLERK',2900.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (191,'Randall','Perkins','RPERKINS','650.505.4876','19-DEC-2007','SH_CLERK',2500.00,0.00,122,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (192,'Sarah','Bell','SBELL','650.501.1876','04-FEB-2004','SH_CLERK',4000.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (193,'Britney','Everett','BEVERETT','650.501.2876','03-MAR-2005','SH_CLERK',3900.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (194,'Samuel','McCain','SMCCAIN','650.501.3876','01-JUL-2006','SH_CLERK',3200.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (195,'Vance','Jones','VJONES','650.501.4876','17-MAR-2007','SH_CLERK',2800.00,0.00,123,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (196,'Alana','Walsh','AWALSH','650.507.9811','24-APR-2006','SH_CLERK',3100.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (197,'Kevin','Feeney','KFEENEY','650.507.9822','23-MAY-2006','SH_CLERK',3000.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (198,'Donald','OConnell','DOCONNEL','650.507.9833','21-JUN-2007','SH_CLERK',2600.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (199,'Douglas','Grant','DGRANT','650.507.9844','13-JAN-2008','SH_CLERK',2600.00,0.00,124,50);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (200,'Jennifer','Whalen','JWHALEN','515.123.4444','17-SEP-2003','AD_ASST',4400.00,0.00,101,10);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (201,'Michael','Hartstein','MHARTSTE','515.123.5555','17-FEB-2004','MK_MAN',13000.00,0.00,100,20);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (202,'Pat','Fay','PFAY','603.123.6666','17-AUG-2005','MK_REP',6000.00,0.00,201,20);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (203,'Susan','Mavris','SMAVRIS','515.123.7777','07-JUN-2002','HR_REP',6500.00,0.00,101,40);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (204,'Hermann','Baer','HBAER','515.123.8888','07-JUN-2002','PR_REP',10000.00,0.00,101,70);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (205,'Shelley','Higgins','SHIGGINS','515.123.8080','07-JUN-2002','AC_MGR',12000.00,0.00,101,110);
INSERT INTO employees (employee_id,first_name,last_name,email,phone_number,hire_date,job_id,salary,commission_pct,manager_id,department_id) VALUES  (206,'William','Gietz','WGIETZ','515.123.8181','07-JUN-2002','AC_ACCOUNT',8300.00,0.00,205,110);
select * from employees;
select first_name,last_name,job_id,salary from employees;
drop table employees;

Output:

  	EMPLOYEE_ID	FIRST_NAME	LAST_NAME	EMAIL	PHONE_NUMBER	HIRE_DATE	JOB_ID	SALARY	COMMISSION_PCT	MANAGER_ID	DEPARTMENT_ID
1	100	Steven	King	SKING	515.123.4567	6/17/2003 12:00:00 AM	AD_PRES	24000	0	0	90
2	101	Neena	Kochhar	NKOCHHAR	515.123.4568	9/21/2005 12:00:00 AM	AD_VP	17000	0	100	90
3	102	Lex	De Haan	LDEHAAN	515.123.4569	1/13/2001 12:00:00 AM	AD_VP	17000	0	100	90
4	103	Alexander	Hunold	AHUNOLD	590.423.4567	1/3/2006 12:00:00 AM	IT_PROG	9000	0	102	60
5	104	Bruce	Ernst	BERNST	590.423.4568	5/21/2007 12:00:00 AM	IT_PROG	6000	0	103	60
6	105	David	Austin	DAUSTIN	590.423.4569	6/25/2005 12:00:00 AM	IT_PROG	4800	0	103	60
7	106	Valli	Pataballa	VPATABAL	590.423.4560	2/5/2006 12:00:00 AM	IT_PROG	4800	0	103	60
8	107	Diana	Lorentz	DLORENTZ	590.423.5567	2/7/2007 12:00:00 AM	IT_PROG	4200	0	103	60
9	108	Nancy	Greenberg	NGREENBE	515.124.4569	8/17/2002 12:00:00 AM	FI_MGR	12000	0	101	100
10	109	Daniel	Faviet	DFAVIET	515.124.4169	8/16/2002 12:00:00 AM	FI_ACCOUNT	9000	0	108	100
11	110	John	Chen	JCHEN	515.124.4269	9/28/2005 12:00:00 AM	FI_ACCOUNT	8200	0	108	100
12	111	Ismael	Sciarra	ISCIARRA	515.124.4369	9/30/2005 12:00:00 AM	FI_ACCOUNT	7700	0	108	100
13	112	Jose Manuel	Urman	JMURMAN	515.124.4469	3/7/2006 12:00:00 AM	FI_ACCOUNT	7800	0	108	100
14	113	Luis	Popp	LPOPP	515.124.4567	12/7/2007 12:00:00 AM	FI_ACCOUNT	6900	0	108	100
15	114	Den	Raphaely	DRAPHEAL	515.127.4561	12/7/2002 12:00:00 AM	PU_MAN	11000	0	100	30
16	115	Alexander	Khoo	AKHOO	515.127.4562	5/18/2003 12:00:00 AM	PU_CLERK	3100	0	114	30
17	116	Shelli	Baida	SBAIDA	515.127.4563	12/24/2005 12:00:00 AM	PU_CLERK	2900	0	114	30
18	117	Sigal	Tobias	STOBIAS	515.127.4564	7/24/2005 12:00:00 AM	PU_CLERK	2800	0	114	30
19	118	Guy	Himuro	GHIMURO	515.127.4565	11/15/2006 12:00:00 AM	PU_CLERK	2600	0	114	30
20	119	Karen	Colmenares	KCOLMENA	515.127.4566	8/10/2007 12:00:00 AM	PU_CLERK	2500	0	114	30
21	120	Matthew	Weiss	MWEISS	650.123.1234	7/18/2004 12:00:00 AM	ST_MAN	8000	0	100	50
22	121	Adam	Fripp	AFRIPP	650.123.2234	4/10/2005 12:00:00 AM	ST_MAN	8200	0	100	50
23	122	Payam	Kaufling	PKAUFLIN	650.123.3234	5/1/2003 12:00:00 AM	ST_MAN	7900	0	100	50
24	123	Shanta	Vollman	SVOLLMAN	650.123.4234	10/10/2005 12:00:00 AM	ST_MAN	6500	0	100	50
25	124	Kevin	Mourgos	KMOURGOS	650.123.5234	11/16/2007 12:00:00 AM	ST_MAN	5800	0	100	50
26	125	Julia	Nayer	JNAYER	650.124.1214	7/16/2005 12:00:00 AM	ST_CLERK	3200	0	120	50
27	126	Irene	Mikkilineni	IMIKKILI	650.124.1224	9/28/2006 12:00:00 AM	ST_CLERK	2700	0	120	50
28	127	James	Landry	JLANDRY	650.124.1334	1/14/2007 12:00:00 AM	ST_CLERK	2400	0	120	50
29	128	Steven	Markle	SMARKLE	650.124.1434	3/8/2008 12:00:00 AM	ST_CLERK	2200	0	120	50
30	129	Laura	Bissot	LBISSOT	650.124.5234	8/20/2005 12:00:00 AM	ST_CLERK	3300	0	121	50
31	130	Mozhe	Atkinson	MATKINSO	650.124.6234	10/30/2005 12:00:00 AM	ST_CLERK	2800	0	121	50
32	131	James	Marlow	JAMRLOW	650.124.7234	2/16/2005 12:00:00 AM	ST_CLERK	2500	0	121	50
33	132	TJ	Olson	TJOLSON	650.124.8234	4/10/2007 12:00:00 AM	ST_CLERK	2100	0	121	50
34	133	Jason	Mallin	JMALLIN	650.127.1934	6/14/2004 12:00:00 AM	ST_CLERK	3300	0	122	50
35	134	Michael	Rogers	MROGERS	650.127.1834	8/26/2006 12:00:00 AM	ST_CLERK	2900	0	122	50
36	135	Ki	Gee	KGEE	650.127.1734	12/12/2007 12:00:00 AM	ST_CLERK	2400	0	122	50
37	136	Hazel	Philtanker	HPHILTAN	650.127.1634	2/6/2008 12:00:00 AM	ST_CLERK	2200	0	122	50
38	137	Renske	Ladwig	RLADWIG	650.121.1234	7/14/2003 12:00:00 AM	ST_CLERK	3600	0	123	50
39	138	Stephen	Stiles	SSTILES	650.121.2034	10/26/2005 12:00:00 AM	ST_CLERK	3200	0	123	50
40	139	John	Seo	JSEO	650.121.2019	2/12/2006 12:00:00 AM	ST_CLERK	2700	0	123	50
41	140	Joshua	Patel	JPATEL	650.121.1834	4/6/2006 12:00:00 AM	ST_CLERK	2500	0	123	50
42	141	Trenna	Rajs	TRAJS	650.121.8009	10/17/2003 12:00:00 AM	ST_CLERK	3500	0	124	50
43	142	Curtis	Davies	CDAVIES	650.121.2994	1/29/2005 12:00:00 AM	ST_CLERK	3100	0	124	50
44	143	Randall	Matos	RMATOS	650.121.2874	3/15/2006 12:00:00 AM	ST_CLERK	2600	0	124	50
45	144	Peter	Vargas	PVARGAS	650.121.2004	7/9/2006 12:00:00 AM	ST_CLERK	2500	0	124	50
46	145	John	Russell	JRUSSEL	011.44.1344.429268	1/1/2004 12:00:00 AM	SA_MAN	14000	0.4	100	80
47	146	Karen	Partners	KPARTNER	011.44.1344.467268	1/5/2005 12:00:00 AM	SA_MAN	13500	0.3	100	80
48	147	Alberto	Errazuriz	AERRAZUR	011.44.1344.429278	3/10/2005 12:00:00 AM	SA_MAN	12000	0.3	100	80
49	148	Gerald	Cambrault	GCAMBRAU	011.44.1344.619268	10/15/2007 12:00:00 AM	SA_MAN	11000	0.3	100	80
50	149	Eleni	Zlotkey	EZLOTKEY	011.44.1344.429018	1/29/2008 12:00:00 AM	SA_MAN	10500	0.2	100	80
51	150	Peter	Tucker	PTUCKER	011.44.1344.129268	1/30/2005 12:00:00 AM	SA_REP	10000	0.3	145	80
52	151	David	Bernstein	DBERNSTE	011.44.1344.345268	3/24/2005 12:00:00 AM	SA_REP	9500	0.25	145	80
53	152	Peter	Hall	PHALL	011.44.1344.478968	8/20/2005 12:00:00 AM	SA_REP	9000	0.25	145	80
54	153	Christopher	Olsen	COLSEN	011.44.1344.498718	3/30/2006 12:00:00 AM	SA_REP	8000	0.2	145	80
55	154	Nanette	Cambrault	NCAMBRAU	011.44.1344.987668	12/9/2006 12:00:00 AM	SA_REP	7500	0.2	145	80
56	155	Oliver	Tuvault	OTUVAULT	011.44.1344.486508	11/23/2007 12:00:00 AM	SA_REP	7000	0.15	145	80
57	156	Janette	King	JKING	011.44.1345.429268	1/30/2004 12:00:00 AM	SA_REP	10000	0.35	146	80
58	157	Patrick	Sully	PSULLY	011.44.1345.929268	3/4/2004 12:00:00 AM	SA_REP	9500	0.35	146	80
59	158	Allan	McEwen	AMCEWEN	011.44.1345.829268	8/1/2004 12:00:00 AM	SA_REP	9000	0.35	146	80
60	159	Lindsey	Smith	LSMITH	011.44.1345.729268	3/10/2005 12:00:00 AM	SA_REP	8000	0.3	146	80
61	160	Louise	Doran	LDORAN	011.44.1345.629268	12/15/2005 12:00:00 AM	SA_REP	7500	0.3	146	80
62	161	Sarath	Sewall	SSEWALL	011.44.1345.529268	11/3/2006 12:00:00 AM	SA_REP	7000	0.25	146	80
63	162	Clara	Vishney	CVISHNEY	011.44.1346.129268	11/11/2005 12:00:00 AM	SA_REP	10500	0.25	147	80
64	163	Danielle	Greene	DGREENE	011.44.1346.229268	3/19/2007 12:00:00 AM	SA_REP	9500	0.15	147	80
65	164	Mattea	Marvins	MMARVINS	011.44.1346.329268	1/24/2008 12:00:00 AM	SA_REP	7200	0.1	147	80
66	165	David	Lee	DLEE	011.44.1346.529268	2/23/2008 12:00:00 AM	SA_REP	6800	0.1	147	80
67	166	Sundar	Ande	SANDE	011.44.1346.629268	3/24/2008 12:00:00 AM	SA_REP	6400	0.1	147	80
68	167	Amit	Banda	ABANDA	011.44.1346.729268	4/21/2008 12:00:00 AM	SA_REP	6200	0.1	147	80
69	168	Lisa	Ozer	LOZER	011.44.1343.929268	3/11/2005 12:00:00 AM	SA_REP	11500	0.25	148	80
70	169	Harrison	Bloom	HBLOOM	011.44.1343.829268	3/23/2006 12:00:00 AM	SA_REP	10000	0.2	148	80
71	170	Tayler	Fox	TFOX	011.44.1343.729268	1/24/2006 12:00:00 AM	SA_REP	9600	0.2	148	80
72	171	William	Smith	WSMITH	011.44.1343.629268	2/23/2007 12:00:00 AM	SA_REP	7400	0.15	148	80
73	172	Elizabeth	Bates	EBATES	011.44.1343.529268	3/24/2007 12:00:00 AM	SA_REP	7300	0.15	148	80
74	173	Sundita	Kumar	SKUMAR	011.44.1343.329268	4/21/2008 12:00:00 AM	SA_REP	6100	0.1	148	80
75	174	Ellen	Abel	EABEL	011.44.1644.429267	5/11/2004 12:00:00 AM	SA_REP	11000	0.3	149	80
76	175	Alyssa	Hutton	AHUTTON	011.44.1644.429266	3/19/2005 12:00:00 AM	SA_REP	8800	0.25	149	80
77	176	Jonathon	Taylor	JTAYLOR	011.44.1644.429265	3/24/2006 12:00:00 AM	SA_REP	8600	0.2	149	80
78	177	Jack	Livingston	JLIVINGS	011.44.1644.429264	4/23/2006 12:00:00 AM	SA_REP	8400	0.2	149	80
79	178	Kimberely	Grant	KGRANT	011.44.1644.429263	5/24/2007 12:00:00 AM	SA_REP	7000	0.15	149	0
80	179	Charles	Johnson	CJOHNSON	011.44.1644.429262	1/4/2008 12:00:00 AM	SA_REP	6200	0.1	149	80
81	180	Winston	Taylor	WTAYLOR	650.507.9876	1/24/2006 12:00:00 AM	SH_CLERK	3200	0	120	50
82	181	Jean	Fleaur	JFLEAUR	650.507.9877	2/23/2006 12:00:00 AM	SH_CLERK	3100	0	120	50
83	182	Martha	Sullivan	MSULLIVA	650.507.9878	6/21/2007 12:00:00 AM	SH_CLERK	2500	0	120	50
84	183	Girard	Geoni	GGEONI	650.507.9879	2/3/2008 12:00:00 AM	SH_CLERK	2800	0	120	50
85	184	Nandita	Sarchand	NSARCHAN	650.509.1876	1/27/2004 12:00:00 AM	SH_CLERK	4200	0	121	50
86	185	Alexis	Bull	ABULL	650.509.2876	2/20/2005 12:00:00 AM	SH_CLERK	4100	0	121	50
87	186	Julia	Dellinger	JDELLING	650.509.3876	6/24/2006 12:00:00 AM	SH_CLERK	3400	0	121	50
88	187	Anthony	Cabrio	ACABRIO	650.509.4876	2/7/2007 12:00:00 AM	SH_CLERK	3000	0	121	50
89	188	Kelly	Chung	KCHUNG	650.505.1876	6/14/2005 12:00:00 AM	SH_CLERK	3800	0	122	50
90	189	Jennifer	Dilly	JDILLY	650.505.2876	8/13/2005 12:00:00 AM	SH_CLERK	3600	0	122	50
91	190	Timothy	Gates	TGATES	650.505.3876	7/11/2006 12:00:00 AM	SH_CLERK	2900	0	122	50
92	191	Randall	Perkins	RPERKINS	650.505.4876	12/19/2007 12:00:00 AM	SH_CLERK	2500	0	122	50
93	192	Sarah	Bell	SBELL	650.501.1876	2/4/2004 12:00:00 AM	SH_CLERK	4000	0	123	50
94	193	Britney	Everett	BEVERETT	650.501.2876	3/3/2005 12:00:00 AM	SH_CLERK	3900	0	123	50
95	194	Samuel	McCain	SMCCAIN	650.501.3876	7/1/2006 12:00:00 AM	SH_CLERK	3200	0	123	50
96	195	Vance	Jones	VJONES	650.501.4876	3/17/2007 12:00:00 AM	SH_CLERK	2800	0	123	50
97	196	Alana	Walsh	AWALSH	650.507.9811	4/24/2006 12:00:00 AM	SH_CLERK	3100	0	124	50
98	197	Kevin	Feeney	KFEENEY	650.507.9822	5/23/2006 12:00:00 AM	SH_CLERK	3000	0	124	50
99	198	Donald	OConnell	DOCONNEL	650.507.9833	6/21/2007 12:00:00 AM	SH_CLERK	2600	0	124	50
100	199	Douglas	Grant	DGRANT	650.507.9844	1/13/2008 12:00:00 AM	SH_CLERK	2600	0	124	50
101	200	Jennifer	Whalen	JWHALEN	515.123.4444	9/17/2003 12:00:00 AM	AD_ASST	4400	0	101	10
102	201	Michael	Hartstein	MHARTSTE	515.123.5555	2/17/2004 12:00:00 AM	MK_MAN	13000	0	100	20
103	202	Pat	Fay	PFAY	603.123.6666	8/17/2005 12:00:00 AM	MK_REP	6000	0	201	20
104	203	Susan	Mavris	SMAVRIS	515.123.7777	6/7/2002 12:00:00 AM	HR_REP	6500	0	101	40
105	204	Hermann	Baer	HBAER	515.123.8888	6/7/2002 12:00:00 AM	PR_REP	10000	0	101	70
106	205	Shelley	Higgins	SHIGGINS	515.123.8080	6/7/2002 12:00:00 AM	AC_MGR	12000	0	101	110
107	206	William	Gietz	WGIETZ	515.123.8181	6/7/2002 12:00:00 AM	AC_ACCOUNT	8300	0	205	110

  	FIRST_NAME	LAST_NAME	JOB_ID	SALARY
1	Steven	King	AD_PRES	24000
2	Neena	Kochhar	AD_VP	17000
3	Lex	De Haan	AD_VP	17000
4	Alexander	Hunold	IT_PROG	9000
5	Bruce	Ernst	IT_PROG	6000
6	David	Austin	IT_PROG	4800
7	Valli	Pataballa	IT_PROG	4800
8	Diana	Lorentz	IT_PROG	4200
9	Nancy	Greenberg	FI_MGR	12000
10	Daniel	Faviet	FI_ACCOUNT	9000
11	John	Chen	FI_ACCOUNT	8200
12	Ismael	Sciarra	FI_ACCOUNT	7700
13	Jose Manuel	Urman	FI_ACCOUNT	7800
14	Luis	Popp	FI_ACCOUNT	6900
15	Den	Raphaely	PU_MAN	11000
16	Alexander	Khoo	PU_CLERK	3100
17	Shelli	Baida	PU_CLERK	2900
18	Sigal	Tobias	PU_CLERK	2800
19	Guy	Himuro	PU_CLERK	2600
20	Karen	Colmenares	PU_CLERK	2500
21	Matthew	Weiss	ST_MAN	8000
22	Adam	Fripp	ST_MAN	8200
23	Payam	Kaufling	ST_MAN	7900
24	Shanta	Vollman	ST_MAN	6500
25	Kevin	Mourgos	ST_MAN	5800
26	Julia	Nayer	ST_CLERK	3200
27	Irene	Mikkilineni	ST_CLERK	2700
28	James	Landry	ST_CLERK	2400
29	Steven	Markle	ST_CLERK	2200
30	Laura	Bissot	ST_CLERK	3300
31	Mozhe	Atkinson	ST_CLERK	2800
32	James	Marlow	ST_CLERK	2500
33	TJ	Olson	ST_CLERK	2100
34	Jason	Mallin	ST_CLERK	3300
35	Michael	Rogers	ST_CLERK	2900
36	Ki	Gee	ST_CLERK	2400
37	Hazel	Philtanker	ST_CLERK	2200
38	Renske	Ladwig	ST_CLERK	3600
39	Stephen	Stiles	ST_CLERK	3200
40	John	Seo	ST_CLERK	2700
41	Joshua	Patel	ST_CLERK	2500
42	Trenna	Rajs	ST_CLERK	3500
43	Curtis	Davies	ST_CLERK	3100
44	Randall	Matos	ST_CLERK	2600
45	Peter	Vargas	ST_CLERK	2500
46	John	Russell	SA_MAN	14000
47	Karen	Partners	SA_MAN	13500
48	Alberto	Errazuriz	SA_MAN	12000
49	Gerald	Cambrault	SA_MAN	11000
50	Eleni	Zlotkey	SA_MAN	10500
51	Peter	Tucker	SA_REP	10000
52	David	Bernstein	SA_REP	9500
53	Peter	Hall	SA_REP	9000
54	Christopher	Olsen	SA_REP	8000
55	Nanette	Cambrault	SA_REP	7500
56	Oliver	Tuvault	SA_REP	7000
57	Janette	King	SA_REP	10000
58	Patrick	Sully	SA_REP	9500
59	Allan	McEwen	SA_REP	9000
60	Lindsey	Smith	SA_REP	8000
61	Louise	Doran	SA_REP	7500
62	Sarath	Sewall	SA_REP	7000
63	Clara	Vishney	SA_REP	10500
64	Danielle	Greene	SA_REP	9500
65	Mattea	Marvins	SA_REP	7200
66	David	Lee	SA_REP	6800
67	Sundar	Ande	SA_REP	6400
68	Amit	Banda	SA_REP	6200
69	Lisa	Ozer	SA_REP	11500
70	Harrison	Bloom	SA_REP	10000
71	Tayler	Fox	SA_REP	9600
72	William	Smith	SA_REP	7400
73	Elizabeth	Bates	SA_REP	7300
74	Sundita	Kumar	SA_REP	6100
75	Ellen	Abel	SA_REP	11000
76	Alyssa	Hutton	SA_REP	8800
77	Jonathon	Taylor	SA_REP	8600
78	Jack	Livingston	SA_REP	8400
79	Kimberely	Grant	SA_REP	7000
80	Charles	Johnson	SA_REP	6200
81	Winston	Taylor	SH_CLERK	3200
82	Jean	Fleaur	SH_CLERK	3100
83	Martha	Sullivan	SH_CLERK	2500
84	Girard	Geoni	SH_CLERK	2800
85	Nandita	Sarchand	SH_CLERK	4200
86	Alexis	Bull	SH_CLERK	4100
87	Julia	Dellinger	SH_CLERK	3400
88	Anthony	Cabrio	SH_CLERK	3000
89	Kelly	Chung	SH_CLERK	3800
90	Jennifer	Dilly	SH_CLERK	3600
91	Timothy	Gates	SH_CLERK	2900
92	Randall	Perkins	SH_CLERK	2500
93	Sarah	Bell	SH_CLERK	4000
94	Britney	Everett	SH_CLERK	3900
95	Samuel	McCain	SH_CLERK	3200
96	Vance	Jones	SH_CLERK	2800
97	Alana	Walsh	SH_CLERK	3100
98	Kevin	Feeney	SH_CLERK	3000
99	Donald	OConnell	SH_CLERK	2600
100	Douglas	Grant	SH_CLERK	2600
101	Jennifer	Whalen	AD_ASST	4400
102	Michael	Hartstein	MK_MAN	13000
103	Pat	Fay	MK_REP	6000
104	Susan	Mavris	HR_REP	6500
105	Hermann	Baer	PR_REP	10000
106	Shelley	Higgins	AC_MGR	12000
107	William	Gietz	AC_ACCOUNT	8300

Oracle Code Editor:


Improve this sample solution and post your code through Disqus.

Previous: Oracle Queries Basic Exercises Home
Next: Write a Oracle SQL query to display the employee name, job and annual salary for all employees.

What is the difficulty level of this exercise?