Creating Sample SQL Queries using the Oracle LIVE SQL

View All Scripts Login to Run Script

Script Name Creating Sample SQL Queries using the Oracle LIVE SQL
Description Creating Sample SQL Queries using the Oracle LIVE SQL
Area SQL General
Contributor Laxman Kumar Boorugu
Created Monday January 23, 2017

Statement 1

Using Self Joins: Example The following query uses a self join to return the name of each employee along with the name of the employee's manager. A WHERE clause is added to shorten the output.

SELECT e1.last_name||' works for '||e2.last_name   
   "Employees and Their Managers"  
FROM hr.employees e1, hr.employees e2   
WHERE e1.manager_id = e2.employee_id  
      AND e1.last_name LIKE 'R%'  
ORDER BY e1.last_name


Employees and Their Managers
Rajs works for Mourgos
Raphaely works for King
Rogers works for Kaufling
Russell works for King

4 rows selected.

Employees and Their Managers
Rajs works for Mourgos
Raphaely works for King
Rogers works for Kaufling
Russell works for King

Statement 2

LEFT OUTER JOIN example. The following example shows how a partitioned outer join fills data gaps in rows to facilitate analytic function specification and reliable report formatting. The example first creates a small data table to be used in the join.

SELECT d.department_id, e.last_name  
FROM hr.departments d LEFT OUTER JOIN hr.employees e  
ON d.department_id = e.department_id  
ORDER BY d.department_id, e.last_name


DEPARTMENT_ID LAST_NAME
10 Whalen
20 Fay
20 Hartstein
30 Baida
30 Colmenares
30 Himuro
30 Khoo
30 Raphaely
30 Tobias
40 Mavris
50 Atkinson
50 Bell
50 Bissot
50 Bull
50 Cabrio
50 Chung
50 Davies
50 Dellinger
50 Dilly
50 Everett
50 Feeney
50 Fleaur
50 Fripp
50 Gates
50 Gee
50 Geoni
50 Grant
50 Jones
50 Kaufling
50 Ladwig
50 Landry
50 Mallin
50 Markle
50 Marlow
50 Matos
50 McCain
50 Mikkilineni
50 Mourgos
50 Nayer
50 OConnell
50 Olson
50 Patel
50 Perkins
50 Philtanker
50 Rajs
50 Rogers
50 Sarchand
50 Seo
50 Stiles
50 Sullivan

Rows 1 - 50. More rows exist.

DEPARTMENT_ID	LAST_NAME
10	Whalen
20	Fay
20	Hartstein
30	Baida
30	Colmenares
30	Himuro
30	Khoo
30	Raphaely
30	Tobias
40	Mavris
50	Atkinson
50	Bell
50	Bissot
50	Bull
50	Cabrio
50	Chung
50	Davies
50	Dellinger
50	Dilly
50	Everett
50	Feeney
50	Fleaur
50	Fripp
50	Gates
50	Gee
50	Geoni
50	Grant
50	Jones
50	Kaufling
50	Ladwig
50	Landry
50	Mallin
50	Markle
50	Marlow
50	Matos
50	McCain
50	Mikkilineni
50	Mourgos
50	Nayer
50	OConnell
50	Olson
50	Patel
50	Perkins
50	Philtanker
50	Rajs
50	Rogers
50	Sarchand
50	Seo
50	Stiles
50	Sullivan

Statement 3

RIGHT OUTER JOIN example

SELECT d.department_id, e.last_name  
FROM hr.departments d RIGHT OUTER JOIN hr.employees e  
   ON d.department_id = e.department_id  
   ORDER BY d.department_id, e.last_name


DEPARTMENT_ID LAST_NAME
10 Whalen
20 Fay
20 Hartstein
30 Baida
30 Colmenares
30 Himuro
30 Khoo
30 Raphaely
30 Tobias
40 Mavris
50 Atkinson
50 Bell
50 Bissot
50 Bull
50 Cabrio
50 Chung
50 Davies
50 Dellinger
50 Dilly
50 Everett
50 Feeney
50 Fleaur
50 Fripp
50 Gates
50 Gee
50 Geoni
50 Grant
50 Jones
50 Kaufling
50 Ladwig
50 Landry
50 Mallin
50 Markle
50 Marlow
50 Matos
50 McCain
50 Mikkilineni
50 Mourgos
50 Nayer
50 OConnell
50 Olson
50 Patel
50 Perkins
50 Philtanker
50 Rajs
50 Rogers
50 Sarchand
50 Seo
50 Stiles
50 Sullivan

Rows 1 - 50. More rows exist.

DEPARTMENT_ID	LAST_NAME
10	Whalen
20	Fay
20	Hartstein
30	Baida
30	Colmenares
30	Himuro
30	Khoo
30	Raphaely
30	Tobias
40	Mavris
50	Atkinson
50	Bell
50	Bissot
50	Bull
50	Cabrio
50	Chung
50	Davies
50	Dellinger
50	Dilly
50	Everett
50	Feeney
50	Fleaur
50	Fripp
50	Gates
50	Gee
50	Geoni
50	Grant
50	Jones
50	Kaufling
50	Ladwig
50	Landry
50	Mallin
50	Markle
50	Marlow
50	Matos
50	McCain
50	Mikkilineni
50	Mourgos
50	Nayer
50	OConnell
50	Olson
50	Patel
50	Perkins
50	Philtanker
50	Rajs
50	Rogers
50	Sarchand
50	Seo
50	Stiles
50	Sullivan

Statement 4

It is not clear from this result whether employees Grant and Zeuss have department_id NULL, or whether their department_id is not in the departments table. To determine this requires a full outer join.

SELECT d.department_id as d_dept_id, e.department_id as e_dept_id,  
      e.last_name  
FROM hr.departments d FULL OUTER JOIN hr.employees e  
   ON d.department_id = e.department_id  
ORDER BY d.department_id, e.last_name


D_DEPT_ID E_DEPT_ID LAST_NAME
10 10 Whalen
20 20 Fay
20 20 Hartstein
30 30 Baida
30 30 Colmenares
30 30 Himuro
30 30 Khoo
30 30 Raphaely
30 30 Tobias
40 40 Mavris
50 50 Atkinson
50 50 Bell
50 50 Bissot
50 50 Bull
50 50 Cabrio
50 50 Chung
50 50 Davies
50 50 Dellinger
50 50 Dilly
50 50 Everett
50 50 Feeney
50 50 Fleaur
50 50 Fripp
50 50 Gates
50 50 Gee
50 50 Geoni
50 50 Grant
50 50 Jones
50 50 Kaufling
50 50 Ladwig
50 50 Landry
50 50 Mallin
50 50 Markle
50 50 Marlow
50 50 Matos
50 50 McCain
50 50 Mikkilineni
50 50 Mourgos
50 50 Nayer
50 50 OConnell
50 50 Olson
50 50 Patel
50 50 Perkins
50 50 Philtanker
50 50 Rajs
50 50 Rogers
50 50 Sarchand
50 50 Seo
50 50 Stiles
50 50 Sullivan

Rows 1 - 50. More rows exist.

D_DEPT_ID	E_DEPT_ID	LAST_NAME
10	10	Whalen
20	20	Fay
20	20	Hartstein
30	30	Baida
30	30	Colmenares
30	30	Himuro
30	30	Khoo
30	30	Raphaely
30	30	Tobias
40	40	Mavris
50	50	Atkinson
50	50	Bell
50	50	Bissot
50	50	Bull
50	50	Cabrio
50	50	Chung
50	50	Davies
50	50	Dellinger
50	50	Dilly
50	50	Everett
50	50	Feeney
50	50	Fleaur
50	50	Fripp
50	50	Gates
50	50	Gee
50	50	Geoni
50	50	Grant
50	50	Jones
50	50	Kaufling
50	50	Ladwig
50	50	Landry
50	50	Mallin
50	50	Markle
50	50	Marlow
50	50	Matos
50	50	McCain
50	50	Mikkilineni
50	50	Mourgos
50	50	Nayer
50	50	OConnell
50	50	Olson
50	50	Patel
50	50	Perkins
50	50	Philtanker
50	50	Rajs
50	50	Rogers
50	50	Sarchand
50	50	Seo
50	50	Stiles
50	50	Sullivan

Statement 5

Because the column names in this example are the same in both tables in the join, you can also use the common column feature by specifying the USING clause of the join syntax. The output is the same as for the preceding example except that the USING clause coalesces the two matching columns department_id into a single column output.

SELECT department_id AS d_e_dept_id, e.last_name  
FROM hr.departments d FULL OUTER JOIN hr.employees e  
USING (department_id)  
ORDER BY department_id, e.last_name


D_E_DEPT_ID LAST_NAME
10 Whalen
20 Fay
20 Hartstein
30 Baida
30 Colmenares
30 Himuro
30 Khoo
30 Raphaely
30 Tobias
40 Mavris
50 Atkinson
50 Bell
50 Bissot
50 Bull
50 Cabrio
50 Chung
50 Davies
50 Dellinger
50 Dilly
50 Everett
50 Feeney
50 Fleaur
50 Fripp
50 Gates
50 Gee
50 Geoni
50 Grant
50 Jones
50 Kaufling
50 Ladwig
50 Landry
50 Mallin
50 Markle
50 Marlow
50 Matos
50 McCain
50 Mikkilineni
50 Mourgos
50 Nayer
50 OConnell
50 Olson
50 Patel
50 Perkins
50 Philtanker
50 Rajs
50 Rogers
50 Sarchand
50 Seo
50 Stiles
50 Sullivan

Rows 1 - 50. More rows exist.

D_E_DEPT_ID	LAST_NAME
10	Whalen
20	Fay
20	Hartstein
30	Baida
30	Colmenares
30	Himuro
30	Khoo
30	Raphaely
30	Tobias
40	Mavris
50	Atkinson
50	Bell
50	Bissot
50	Bull
50	Cabrio
50	Chung
50	Davies
50	Dellinger
50	Dilly
50	Everett
50	Feeney
50	Fleaur
50	Fripp
50	Gates
50	Gee
50	Geoni
50	Grant
50	Jones
50	Kaufling
50	Ladwig
50	Landry
50	Mallin
50	Markle
50	Marlow
50	Matos
50	McCain
50	Mikkilineni
50	Mourgos
50	Nayer
50	OConnell
50	Olson
50	Patel
50	Perkins
50	Philtanker
50	Rajs
50	Rogers
50	Sarchand
50	Seo
50	Stiles
50	Sullivan

Statement 6

Using Antijoins: Example The following example selects a list of employees who are not in a particular set of departments.

SELECT * FROM hr.employees  
   WHERE department_id NOT IN  
   (SELECT department_id FROM hr.departments  
       WHERE location_id = 1700) 
   ORDER BY last_name


EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
174 Ellen Abel EABEL 011.44.1644.429267 11-MAY-04 SA_REP 11000 .3 149 80
166 Sundar Ande SANDE 011.44.1346.629268 24-MAR-08 SA_REP 6400 .1 147 80
130 Mozhe Atkinson MATKINSO 650.124.6234 30-OCT-05 ST_CLERK 2800  - 121 50
105 David Austin DAUSTIN 590.423.4569 25-JUN-05 IT_PROG 4800  - 103 60
204 Hermann Baer HBAER 515.123.8888 07-JUN-02 PR_REP 10000  - 101 70
167 Amit Banda ABANDA 011.44.1346.729268 21-APR-08 SA_REP 6200 .1 147 80
172 Elizabeth Bates EBATES 011.44.1343.529268 24-MAR-07 SA_REP 7300 .15 148 80
192 Sarah Bell SBELL 650.501.1876 04-FEB-04 SH_CLERK 4000  - 123 50
151 David Bernstein DBERNSTE 011.44.1344.345268 24-MAR-05 SA_REP 9500 .25 145 80
129 Laura Bissot LBISSOT 650.124.5234 20-AUG-05 ST_CLERK 3300  - 121 50
169 Harrison Bloom HBLOOM 011.44.1343.829268 23-MAR-06 SA_REP 10000 .2 148 80
185 Alexis Bull ABULL 650.509.2876 20-FEB-05 SH_CLERK 4100  - 121 50
187 Anthony Cabrio ACABRIO 650.509.4876 07-FEB-07 SH_CLERK 3000  - 121 50
148 Gerald Cambrault GCAMBRAU 011.44.1344.619268 15-OCT-07 SA_MAN 11000 .3 100 80
154 Nanette Cambrault NCAMBRAU 011.44.1344.987668 09-DEC-06 SA_REP 7500 .2 145 80
188 Kelly Chung KCHUNG 650.505.1876 14-JUN-05 SH_CLERK 3800  - 122 50
142 Curtis Davies CDAVIES 650.121.2994 29-JAN-05 ST_CLERK 3100  - 124 50
186 Julia Dellinger JDELLING 650.509.3876 24-JUN-06 SH_CLERK 3400  - 121 50
189 Jennifer Dilly JDILLY 650.505.2876 13-AUG-05 SH_CLERK 3600  - 122 50
160 Louise Doran LDORAN 011.44.1345.629268 15-DEC-05 SA_REP 7500 .3 146 80
104 Bruce Ernst BERNST 590.423.4568 21-MAY-07 IT_PROG 6000  - 103 60
147 Alberto Errazuriz AERRAZUR 011.44.1344.429278 10-MAR-05 SA_MAN 12000 .3 100 80
193 Britney Everett BEVERETT 650.501.2876 03-MAR-05 SH_CLERK 3900  - 123 50
202 Pat Fay PFAY 603.123.6666 17-AUG-05 MK_REP 6000  - 201 20
197 Kevin Feeney KFEENEY 650.507.9822 23-MAY-06 SH_CLERK 3000  - 124 50
181 Jean Fleaur JFLEAUR 650.507.9877 23-FEB-06 SH_CLERK 3100  - 120 50
170 Tayler Fox TFOX 011.44.1343.729268 24-JAN-06 SA_REP 9600 .2 148 80
121 Adam Fripp AFRIPP 650.123.2234 10-APR-05 ST_MAN 8200  - 100 50
190 Timothy Gates TGATES 650.505.3876 11-JUL-06 SH_CLERK 2900  - 122 50
135 Ki Gee KGEE 650.127.1734 12-DEC-07 ST_CLERK 2400  - 122 50
183 Girard Geoni GGEONI 650.507.9879 03-FEB-08 SH_CLERK 2800  - 120 50
199 Douglas Grant DGRANT 650.507.9844 13-JAN-08 SH_CLERK 2600  - 124 50
163 Danielle Greene DGREENE 011.44.1346.229268 19-MAR-07 SA_REP 9500 .15 147 80
152 Peter Hall PHALL 011.44.1344.478968 20-AUG-05 SA_REP 9000 .25 145 80
201 Michael Hartstein MHARTSTE 515.123.5555 17-FEB-04 MK_MAN 13000  - 100 20
103 Alexander Hunold AHUNOLD 590.423.4567 03-JAN-06 IT_PROG 9000  - 102 60
175 Alyssa Hutton AHUTTON 011.44.1644.429266 19-MAR-05 SA_REP 8800 .25 149 80
179 Charles Johnson CJOHNSON 011.44.1644.429262 04-JAN-08 SA_REP 6200 .1 149 80
195 Vance Jones VJONES 650.501.4876 17-MAR-07 SH_CLERK 2800  - 123 50
122 Payam Kaufling PKAUFLIN 650.123.3234 01-MAY-03 ST_MAN 7900  - 100 50
156 Janette King JKING 011.44.1345.429268 30-JAN-04 SA_REP 10000 .35 146 80
173 Sundita Kumar SKUMAR 011.44.1343.329268 21-APR-08 SA_REP 6100 .1 148 80
137 Renske Ladwig RLADWIG 650.121.1234 14-JUL-03 ST_CLERK 3600  - 123 50
127 James Landry JLANDRY 650.124.1334 14-JAN-07 ST_CLERK 2400  - 120 50
165 David Lee DLEE 011.44.1346.529268 23-FEB-08 SA_REP 6800 .1 147 80
177 Jack Livingston JLIVINGS 011.44.1644.429264 23-APR-06 SA_REP 8400 .2 149 80
107 Diana Lorentz DLORENTZ 590.423.5567 07-FEB-07 IT_PROG 4200  - 103 60
133 Jason Mallin JMALLIN 650.127.1934 14-JUN-04 ST_CLERK 3300  - 122 50
128 Steven Markle SMARKLE 650.124.1434 08-MAR-08 ST_CLERK 2200  - 120 50
131 James Marlow JAMRLOW 650.124.7234 16-FEB-05 ST_CLERK 2500  - 121 50

Rows 1 - 50. More rows exist.

EMPLOYEE_ID	FIRST_NAME	LAST_NAME	EMAIL	PHONE_NUMBER	HIRE_DATE	JOB_ID	SALARY	COMMISSION_PCT	MANAGER_ID	DEPARTMENT_ID
174	Ellen	Abel	EABEL	011.44.1644.429267	11-MAY-04	SA_REP	11000	.3	149	80
166	Sundar	Ande	SANDE	011.44.1346.629268	24-MAR-08	SA_REP	6400	.1	147	80
130	Mozhe	Atkinson	MATKINSO	650.124.6234	30-OCT-05	ST_CLERK	2800	-	121	50
105	David	Austin	DAUSTIN	590.423.4569	25-JUN-05	IT_PROG	4800	-	103	60
204	Hermann	Baer	HBAER	515.123.8888	07-JUN-02	PR_REP	10000	-	101	70
167	Amit	Banda	ABANDA	011.44.1346.729268	21-APR-08	SA_REP	6200	.1	147	80
172	Elizabeth	Bates	EBATES	011.44.1343.529268	24-MAR-07	SA_REP	7300	.15	148	80
192	Sarah	Bell	SBELL	650.501.1876	04-FEB-04	SH_CLERK	4000	-	123	50
151	David	Bernstein	DBERNSTE	011.44.1344.345268	24-MAR-05	SA_REP	9500	.25	145	80
129	Laura	Bissot	LBISSOT	650.124.5234	20-AUG-05	ST_CLERK	3300	-	121	50
169	Harrison	Bloom	HBLOOM	011.44.1343.829268	23-MAR-06	SA_REP	10000	.2	148	80
185	Alexis	Bull	ABULL	650.509.2876	20-FEB-05	SH_CLERK	4100	-	121	50
187	Anthony	Cabrio	ACABRIO	650.509.4876	07-FEB-07	SH_CLERK	3000	-	121	50
148	Gerald	Cambrault	GCAMBRAU	011.44.1344.619268	15-OCT-07	SA_MAN	11000	.3	100	80
154	Nanette	Cambrault	NCAMBRAU	011.44.1344.987668	09-DEC-06	SA_REP	7500	.2	145	80
188	Kelly	Chung	KCHUNG	650.505.1876	14-JUN-05	SH_CLERK	3800	-	122	50
142	Curtis	Davies	CDAVIES	650.121.2994	29-JAN-05	ST_CLERK	3100	-	124	50
186	Julia	Dellinger	JDELLING	650.509.3876	24-JUN-06	SH_CLERK	3400	-	121	50
189	Jennifer	Dilly	JDILLY	650.505.2876	13-AUG-05	SH_CLERK	3600	-	122	50
160	Louise	Doran	LDORAN	011.44.1345.629268	15-DEC-05	SA_REP	7500	.3	146	80
104	Bruce	Ernst	BERNST	590.423.4568	21-MAY-07	IT_PROG	6000	-	103	60
147	Alberto	Errazuriz	AERRAZUR	011.44.1344.429278	10-MAR-05	SA_MAN	12000	.3	100	80
193	Britney	Everett	BEVERETT	650.501.2876	03-MAR-05	SH_CLERK	3900	-	123	50
202	Pat	Fay	PFAY	603.123.6666	17-AUG-05	MK_REP	6000	-	201	20
197	Kevin	Feeney	KFEENEY	650.507.9822	23-MAY-06	SH_CLERK	3000	-	124	50
181	Jean	Fleaur	JFLEAUR	650.507.9877	23-FEB-06	SH_CLERK	3100	-	120	50
170	Tayler	Fox	TFOX	011.44.1343.729268	24-JAN-06	SA_REP	9600	.2	148	80
121	Adam	Fripp	AFRIPP	650.123.2234	10-APR-05	ST_MAN	8200	-	100	50
190	Timothy	Gates	TGATES	650.505.3876	11-JUL-06	SH_CLERK	2900	-	122	50
135	Ki	Gee	KGEE	650.127.1734	12-DEC-07	ST_CLERK	2400	-	122	50
183	Girard	Geoni	GGEONI	650.507.9879	03-FEB-08	SH_CLERK	2800	-	120	50
199	Douglas	Grant	DGRANT	650.507.9844	13-JAN-08	SH_CLERK	2600	-	124	50
163	Danielle	Greene	DGREENE	011.44.1346.229268	19-MAR-07	SA_REP	9500	.15	147	80
152	Peter	Hall	PHALL	011.44.1344.478968	20-AUG-05	SA_REP	9000	.25	145	80
201	Michael	Hartstein	MHARTSTE	515.123.5555	17-FEB-04	MK_MAN	13000	-	100	20
103	Alexander	Hunold	AHUNOLD	590.423.4567	03-JAN-06	IT_PROG	9000	-	102	60
175	Alyssa	Hutton	AHUTTON	011.44.1644.429266	19-MAR-05	SA_REP	8800	.25	149	80
179	Charles	Johnson	CJOHNSON	011.44.1644.429262	04-JAN-08	SA_REP	6200	.1	149	80
195	Vance	Jones	VJONES	650.501.4876	17-MAR-07	SH_CLERK	2800	-	123	50
122	Payam	Kaufling	PKAUFLIN	650.123.3234	01-MAY-03	ST_MAN	7900	-	100	50
156	Janette	King	JKING	011.44.1345.429268	30-JAN-04	SA_REP	10000	.35	146	80
173	Sundita	Kumar	SKUMAR	011.44.1343.329268	21-APR-08	SA_REP	6100	.1	148	80
137	Renske	Ladwig	RLADWIG	650.121.1234	14-JUL-03	ST_CLERK	3600	-	123	50
127	James	Landry	JLANDRY	650.124.1334	14-JAN-07	ST_CLERK	2400	-	120	50
165	David	Lee	DLEE	011.44.1346.529268	23-FEB-08	SA_REP	6800	.1	147	80
177	Jack	Livingston	JLIVINGS	011.44.1644.429264	23-APR-06	SA_REP	8400	.2	149	80
107	Diana	Lorentz	DLORENTZ	590.423.5567	07-FEB-07	IT_PROG	4200	-	103	60
133	Jason	Mallin	JMALLIN	650.127.1934	14-JUN-04	ST_CLERK	3300	-	122	50
128	Steven	Markle	SMARKLE	650.124.1434	08-MAR-08	ST_CLERK	2200	-	120	50
131	James	Marlow	JAMRLOW	650.124.7234	16-FEB-05	ST_CLERK	2500	-	121	50

Statement 7

Using Semijoins: Example In the following example, only one row needs to be returned from the departments table, even though many rows in the employees table might match the subquery. If no index has been defined on the salary column in employees, then a semijoin can be used to improve query performance.

SELECT * FROM hr.departments  
   WHERE EXISTS  
   (SELECT * FROM hr.employees  
       WHERE departments.department_id = employees.department_id  
       AND employees.salary > 2500) 
   ORDER BY department_name


DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
110 Accounting 205 1700
10 Administration 200 1700
90 Executive 100 1700
100 Finance 108 1700
40 Human Resources 203 2400
60 IT 103 1400
20 Marketing 201 1800
70 Public Relations 204 2700
30 Purchasing 114 1700
80 Sales 145 2500
50 Shipping 121 1500

11 rows selected.

Statement 8
```
select * from employees
```
```
ORA-00942: table or view does not exist
```
More Details: https://docs.oracle.com/error-help/db/ora-00942
Statement 9
```
select * from emp
```
```
ORA-00942: table or view does not exist
```
More Details: https://docs.oracle.com/error-help/db/ora-00942

DEPARTMENT_ID	DEPARTMENT_NAME	MANAGER_ID	LOCATION_ID
110	Accounting	205	1700
10	Administration	200	1700
90	Executive	100	1700
100	Finance	108	1700
40	Human Resources	203	2400
60	IT	103	1400
20	Marketing	201	1800
70	Public Relations	204	2700
30	Purchasing	114	1700
80	Sales	145	2500
50	Shipping	121	1500

Statement 10

select * from hr.employees where length(last_name)=5 or length(last_name)=10 order by length(last_name) desc


EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
119 Karen Colmenares KCOLMENA 515.127.4566 10-AUG-07 PU_CLERK 2500  - 114 30
136 Hazel Philtanker HPHILTAN 650.127.1634 06-FEB-08 ST_CLERK 2200  - 122 50
177 Jack Livingston JLIVINGS 011.44.1644.429264 23-APR-06 SA_REP 8400 .2 149 80
120 Matthew Weiss MWEISS 650.123.1234 18-JUL-04 ST_MAN 8000  - 100 50
121 Adam Fripp AFRIPP 650.123.2234 10-APR-05 ST_MAN 8200  - 100 50
125 Julia Nayer JNAYER 650.124.1214 16-JUL-05 ST_CLERK 3200  - 120 50
132 TJ Olson TJOLSON 650.124.8234 10-APR-07 ST_CLERK 2100  - 121 50
140 Joshua Patel JPATEL 650.121.1834 06-APR-06 ST_CLERK 2500  - 123 50
143 Randall Matos RMATOS 650.121.2874 15-MAR-06 ST_CLERK 2600  - 124 50
153 Christopher Olsen COLSEN 011.44.1344.498718 30-MAR-06 SA_REP 8000 .2 145 80
157 Patrick Sully PSULLY 011.44.1345.929268 04-MAR-04 SA_REP 9500 .35 146 80
159 Lindsey Smith LSMITH 011.44.1345.729268 10-MAR-05 SA_REP 8000 .3 146 80
160 Louise Doran LDORAN 011.44.1345.629268 15-DEC-05 SA_REP 7500 .3 146 80
167 Amit Banda ABANDA 011.44.1346.729268 21-APR-08 SA_REP 6200 .1 147 80
169 Harrison Bloom HBLOOM 011.44.1343.829268 23-MAR-06 SA_REP 10000 .2 148 80
171 William Smith WSMITH 011.44.1343.629268 23-FEB-07 SA_REP 7400 .15 148 80
172 Elizabeth Bates EBATES 011.44.1343.529268 24-MAR-07 SA_REP 7300 .15 148 80
173 Sundita Kumar SKUMAR 011.44.1343.329268 21-APR-08 SA_REP 6100 .1 148 80
178 Kimberely Grant KGRANT 011.44.1644.429263 24-MAY-07 SA_REP 7000 .15 149  - 
183 Girard Geoni GGEONI 650.507.9879 03-FEB-08 SH_CLERK 2800  - 120 50
188 Kelly Chung KCHUNG 650.505.1876 14-JUN-05 SH_CLERK 3800  - 122 50
189 Jennifer Dilly JDILLY 650.505.2876 13-AUG-05 SH_CLERK 3600  - 122 50
190 Timothy Gates TGATES 650.505.3876 11-JUL-06 SH_CLERK 2900  - 122 50
195 Vance Jones VJONES 650.501.4876 17-MAR-07 SH_CLERK 2800  - 123 50
196 Alana Walsh AWALSH 650.507.9811 24-APR-06 SH_CLERK 3100  - 124 50
199 Douglas Grant DGRANT 650.507.9844 13-JAN-08 SH_CLERK 2600  - 124 50
116 Shelli Baida SBAIDA 515.127.4563 24-DEC-05 PU_CLERK 2900  - 114 30
206 William Gietz WGIETZ 515.123.8181 07-JUN-02 AC_ACCOUNT 8300  - 205 110
104 Bruce Ernst BERNST 590.423.4568 21-MAY-07 IT_PROG 6000  - 103 60
112 Jose Manuel Urman JMURMAN 515.124.4469 07-MAR-06 FI_ACCOUNT 7800  - 108 100

30 rows selected.

EMPLOYEE_ID	FIRST_NAME	LAST_NAME	EMAIL	PHONE_NUMBER	HIRE_DATE	JOB_ID	SALARY	COMMISSION_PCT	MANAGER_ID	DEPARTMENT_ID
119	Karen	Colmenares	KCOLMENA	515.127.4566	10-AUG-07	PU_CLERK	2500	-	114	30
136	Hazel	Philtanker	HPHILTAN	650.127.1634	06-FEB-08	ST_CLERK	2200	-	122	50
177	Jack	Livingston	JLIVINGS	011.44.1644.429264	23-APR-06	SA_REP	8400	.2	149	80
120	Matthew	Weiss	MWEISS	650.123.1234	18-JUL-04	ST_MAN	8000	-	100	50
121	Adam	Fripp	AFRIPP	650.123.2234	10-APR-05	ST_MAN	8200	-	100	50
125	Julia	Nayer	JNAYER	650.124.1214	16-JUL-05	ST_CLERK	3200	-	120	50
132	TJ	Olson	TJOLSON	650.124.8234	10-APR-07	ST_CLERK	2100	-	121	50
140	Joshua	Patel	JPATEL	650.121.1834	06-APR-06	ST_CLERK	2500	-	123	50
143	Randall	Matos	RMATOS	650.121.2874	15-MAR-06	ST_CLERK	2600	-	124	50
153	Christopher	Olsen	COLSEN	011.44.1344.498718	30-MAR-06	SA_REP	8000	.2	145	80
157	Patrick	Sully	PSULLY	011.44.1345.929268	04-MAR-04	SA_REP	9500	.35	146	80
159	Lindsey	Smith	LSMITH	011.44.1345.729268	10-MAR-05	SA_REP	8000	.3	146	80
160	Louise	Doran	LDORAN	011.44.1345.629268	15-DEC-05	SA_REP	7500	.3	146	80
167	Amit	Banda	ABANDA	011.44.1346.729268	21-APR-08	SA_REP	6200	.1	147	80
169	Harrison	Bloom	HBLOOM	011.44.1343.829268	23-MAR-06	SA_REP	10000	.2	148	80
171	William	Smith	WSMITH	011.44.1343.629268	23-FEB-07	SA_REP	7400	.15	148	80
172	Elizabeth	Bates	EBATES	011.44.1343.529268	24-MAR-07	SA_REP	7300	.15	148	80
173	Sundita	Kumar	SKUMAR	011.44.1343.329268	21-APR-08	SA_REP	6100	.1	148	80
178	Kimberely	Grant	KGRANT	011.44.1644.429263	24-MAY-07	SA_REP	7000	.15	149	-
183	Girard	Geoni	GGEONI	650.507.9879	03-FEB-08	SH_CLERK	2800	-	120	50
188	Kelly	Chung	KCHUNG	650.505.1876	14-JUN-05	SH_CLERK	3800	-	122	50
189	Jennifer	Dilly	JDILLY	650.505.2876	13-AUG-05	SH_CLERK	3600	-	122	50
190	Timothy	Gates	TGATES	650.505.3876	11-JUL-06	SH_CLERK	2900	-	122	50
195	Vance	Jones	VJONES	650.501.4876	17-MAR-07	SH_CLERK	2800	-	123	50
196	Alana	Walsh	AWALSH	650.507.9811	24-APR-06	SH_CLERK	3100	-	124	50
199	Douglas	Grant	DGRANT	650.507.9844	13-JAN-08	SH_CLERK	2600	-	124	50
116	Shelli	Baida	SBAIDA	515.127.4563	24-DEC-05	PU_CLERK	2900	-	114	30
206	William	Gietz	WGIETZ	515.123.8181	07-JUN-02	AC_ACCOUNT	8300	-	205	110
104	Bruce	Ernst	BERNST	590.423.4568	21-MAY-07	IT_PROG	6000	-	103	60
112	Jose Manuel	Urman	JMURMAN	515.124.4469	07-MAR-06	FI_ACCOUNT	7800	-	108	100

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database