Question: Using Oracle SQLPLUS for the following: A. Populate them with given test data to that is relevant to the questions listed below. List the screenshots
Using Oracle SQLPLUS for the following:
A. Populate them with given test data to that is relevant to the questions listed below. List the screenshots of the SQL Command used and the overall rows of the table with image of it resulting output. Include the screenshot of the INSERT SQL Statement used to populate table data along with the TABLE's CONTENT displayed using SELECT statements.
Store System
Table Name: Product
| ProductCode | Product_name | Unit_Price |
| P1 | Noodles | 30 |
| P2 | Rice | 900 |
| P3 | Coffee | 400 |
| P4 | Oil | 200 |
| P5 | Biscuits | 60 |
| P6 | Dishwasher | 90 |
Table Name: Order Details
| Order _id | Product _id | Custom er_id | Customer_nam e | Customer _address | Order_date | Quantity |
| Ord1 | P3 | C1 | Saroj Karki | Add1 | 2020-01-20 | 3 |
| Ord1 | P4 | C1 | Saroj Karki | Add1 | 2020-01-20 | 4 |
| Ord2 | P5 | C2 | Rohit Pandey | Add2 | 2020-04-05 | 2 |
| Ord3 | P3 | C1 | Saroj Karki | Add2 | 2020-04-05 | 1 |
| Ord4 | P2 | C3 | Santos Katuwal | Add3 | 2020-06-25 | 5 |
| Ord4 | P4 | C3 | Santos Katuwal | Add4 | 2020-06-25 | 4 |
| Ord4 | P1 | C3 | Santos Katuwal | Add2 | 2020-06-25 | 4 |
| Ord5 | P6 | C4 | Bidur Khanal | Add1 | 2020-07-21 | 2 |
| Ord6 | P6 | C5 | Kusum Tamang | Add5 | 2020-07-08 | 1 |
| Ord7 | P3 | C3 | Santos Katuwal | Add5 | 2020-04-03 | 6 |
Table Name: Address
| Address_i d | Country | Zone | City |
| Add1 | Nepal | Koshi | Itahari |
| Add2 | Nepal | Mechi | Jhapa |
| Add3 | Nepal | Bagmati | Kathmandu |
| Add4 | Nepal | Bagmati | Lalitpur |
| Add5 | Nepal | Koshi | Dharan |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
