using oracle

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter6: Updating Data
Section: Chapter Questions
Problem 12CAT
icon
Related questions
Question

using oracle

using oracle
8- Write a SQL query to display the item name, price, and company name
of all the products?
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
EMP IDNO EMP_FNAME
127323 Michale
526689 Carlos:
843795 Enric
328717 Jhon
444527 Joseph
659831 Zanifer
847674 Kuleswar
748681 Henrey
PRO_PRICE
aid Bab
555935 Alex
539569 George
733843 Mario
631548 Alan
839139 Maria.
EMP_LNAME
Robbin
Snares
Dosio
Snares
Dosni
Emily
55000
75000
Sitaraman
Gabriel
Manuel
Mardy
Saule
Snappy
Foster
abah
EMP_DEPT
57
63
57
63
47
47
57
47
57
27
63
27
57
Transcribed Image Text:using oracle 8- Write a SQL query to display the item name, price, and company name of all the products? 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 EMP IDNO EMP_FNAME 127323 Michale 526689 Carlos: 843795 Enric 328717 Jhon 444527 Joseph 659831 Zanifer 847674 Kuleswar 748681 Henrey PRO_PRICE aid Bab 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria. EMP_LNAME Robbin Snares Dosio Snares Dosni Emily 55000 75000 Sitaraman Gabriel Manuel Mardy Saule Snappy Foster abah EMP_DEPT 57 63 57 63 47 47 57 47 57 27 63 27 57
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Database Environment
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
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
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