using oracle
Chapter6: Updating Data
Section: Chapter Questions
Problem 12CAT
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7563f763-7770-4395-829c-5492caf2547a%2Fca1bd9a0-663c-4a98-9914-e337b1ffa540%2Fs2jjoqq_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)