Use: SQL - APEX Oracle Data BaseUse the following tables from APEX Oracle select * from oehr_departments (tables are included for reference)select * from oehr_employees (tables are included for reference)Write a query to find, name, hire_date, phone_number, department name for the employees in HR database. Retrieve only matching data. Write this query by using WHERE clause and JOIN keyword ΕMPLOYΕE_IDFIRST_NAMELAST_NAMEEMAILPHONE_NUMBERHIRE_DATEJOB_IDSALARYCOMMISSION_PCTMANAGER_IDDEPARTMENT_ID100StevenKingSKING515.123.456710/13/2007AD PRES2400090101NeenaKochharNKOCHHAR515.123.456801/17/2010AD VP1700010090102LexDe HaanLDEHAAN515.123.456905/11/2013AD_VP1700010090103AlexanderHunoldAHUNOLD590.423.456705/01/2010IT_PROG900010260104BruceErnstBERNST590.423.456809/16/2011IT_PROG600010360105DavidAustinDAUSTIN590.423.456910/21/2017IT PROG480010360106ValliPataballaVРАТАВAL590.423.456006/03/2018IT PROG480010360107DianaLorentzDLORENTZ590.423.556706/05/2019IT PROG420010360108NancyGreenbergNGREENBE515.124.456912/13/2014FI_MGR12000101100109DanielFavietDFAVIET515.124.416912/12/2014FLACCOUNT9000108100 DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID10Administration200170020Marketing201180030Purchasing114170040Human Resources203240050Shipping121150060IT1031400

oehr_departments and oehr_employees are connected by department_id and manager_id in both the tables…

Answered: Write a query to find, name, hire_date,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Use: SQL - APEX Oracle Data Base

Use the following tables from APEX Oracle

select * from oehr_departments (tables are included for reference)

select * from oehr_employees (tables are included for reference)

Write a query to find, name, hire_date, phone_number, department name for the employees in HR database. Retrieve only matching data. Write this query by using WHERE clause and JOIN keyword

ΕMPLOYΕE_ID
FIRST_NAME
LAST_NAME
EMAIL
PHONE_NUMBER
HIRE_DATE
JOB_ID
SALARY
COMMISSION_PCT
MANAGER_ID
DEPARTMENT_ID
100
Steven
King
SKING
515.123.4567
10/13/2007
AD PRES
24000
90
101
Neena
Kochhar
NKOCHHAR
515.123.4568
01/17/2010
AD VP
17000
100
90
102
Lex
De Haan
LDEHAAN
515.123.4569
05/11/2013
AD_VP
17000
100
90
103
Alexander
Hunold
AHUNOLD
590.423.4567
05/01/2010
IT_PROG
9000
102
60
104
Bruce
Ernst
BERNST
590.423.4568
09/16/2011
IT_PROG
6000
103
60
105
David
Austin
DAUSTIN
590.423.4569
10/21/2017
IT PROG
4800
103
60
106
Valli
Pataballa
VРАТАВAL
590.423.4560
06/03/2018
IT PROG
4800
103
60
107
Diana
Lorentz
DLORENTZ
590.423.5567
06/05/2019
IT PROG
4200
103
60
108
Nancy
Greenberg
NGREENBE
515.124.4569
12/13/2014
FI_MGR
12000
101
100
109
Daniel
Faviet
DFAVIET
515.124.4169
12/12/2014
FLACCOUNT
9000
108
100

DEPARTMENT_ID
DEPARTMENT_NAME
MANAGER_ID
LOCATION_ID
10
Administration
200
1700
20
Marketing
201
1800
30
Purchasing
114
1700
40
Human Resources
203
2400
50
Shipping
121
1500
60
IT
103
1400

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions