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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started