using oracle 4- From the following tables write a SQL query to display all the data of employees including their department ? company_mast COM ID COM NAME 11 Samsung 12 iBall 13 Epsion 14 Zebronics 15 Asus 16 Frontech item_mast PRO_ID PRO_NAME 101 Mother Board 102 Key Board 103 ZIP drive 104 Speaker 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse emp_department DPT_CODE DPT_NAME 57 IT 63 Finance 47 HR 27 RD 89 QC 127323 Michale 526689 Carlos 843795 Enric 328717 Jhon 444527 Joseph. 659831 Zanifer 847674 Kuleswar 748681 Henrey 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria ha aid PRO_PRICE 3200.00 450.00 Robbin Snares Dosio Snares Dosni Emily EMP LNAME 65000 15000 240000 55000 75000 Sitaraman Gabriel Manuel Mardy Saule Snappy Foster પર્વ 96 EMP DEPT 57 63 57 63 47 47 57 47 57 27 63 27 57

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
icon
Related questions
icon
Concept explainers
Question

using oracle

using oracle
4- From the following tables write a SQL query to display all the data of
employees including their department ?
company_mast
COM ID COM NAME
11 Samsung
12 iBall
13 Epsion.
14 Zebronics
15 Asus
16 Frontech
item_mast
PRO ID PRO_NAME
101 Mother Board
102 Key Board
103 ZIP drive
104 Speaker
105 Monitor
106 DVD drive
107 CD drive
108 Printer
109 Refill cartridge.
110 Mouse
emp_department
DPT_CODE DPT_NAME
57 IT
63 Finance.
47 HR
27 RD
89 QC
127323 Michale
526689 Carlos
843795 Enric
328717 Jhon
444527 Joseph
659831 Zanifer
847674 Kuleswar
748681 Henrey
555935 Alex
539569 George
733843 Mario
631548 Alan
839139 Maria
hat
aid
PRO_PRICE
15000
240000
55000
75000
EMP LNAME
Robbin
Snares
Dosio
Snares
Dosni
Emily
Sitaraman
Gabriel.
Manuel
Mardy
Saule
Snappy
Foster
4123 13 12
abah
que
EMP DEPT
57
63
57
63
47
47
57
47
57
27
63
27
57
Transcribed Image Text:using oracle 4- From the following tables write a SQL query to display all the data of employees including their department ? company_mast COM ID COM NAME 11 Samsung 12 iBall 13 Epsion. 14 Zebronics 15 Asus 16 Frontech item_mast PRO ID PRO_NAME 101 Mother Board 102 Key Board 103 ZIP drive 104 Speaker 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge. 110 Mouse emp_department DPT_CODE DPT_NAME 57 IT 63 Finance. 47 HR 27 RD 89 QC 127323 Michale 526689 Carlos 843795 Enric 328717 Jhon 444527 Joseph 659831 Zanifer 847674 Kuleswar 748681 Henrey 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria hat aid PRO_PRICE 15000 240000 55000 75000 EMP LNAME Robbin Snares Dosio Snares Dosni Emily Sitaraman Gabriel. Manuel Mardy Saule Snappy Foster 4123 13 12 abah que EMP DEPT 57 63 57 63 47 47 57 47 57 27 63 27 57
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education