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 Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 5P: Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is...
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 Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr