using oracle 9- From the following tables write a SQL query to select all rows from both participating tables as long as there is a match between pro_com and com_id?
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
using oracle
![using oracle
9- From the following tables write a SQL query to select all rows from both
participating tables as long as there is a match between pro_com and
com_id?
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_details
EMP IDNO EMP FNAME
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
PRO_PRICE
3200.00
450.00
250.00
aid
DPT ALLOTMENT
abs
PRO COM
240000
55000
75000
Foster
EMP_LNAME
EMP_DEPT
Robbin
57
Snares
63
Dosio
57
Snares
63
Dosni
47
11
Emily
47
Sitaraman
57
Gabriel.
47
Manuel
57
Mardy
27
Saule
63
Snappy
27
57](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7563f763-7770-4395-829c-5492caf2547a%2F3fae114e-1dac-4030-be45-218c9228755e%2Fky9o9tm_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)