plsql

Section (1) - Writing the Program I 10 Marks) Direction: Use the table below for your reference in answering Question 1 and 2. Table Name: Product PID PNAME 1 N Computer Printer Laptop Keyboard Company Toshiba HP Toshiba Fujitsu Price 200 55 250 15 3 4 1. Using the Simple loop iterative control, write a PL/SQL block to display the PID and PNAME of the first Two Products from the Product table. Additional Requirements: Use %TYPE in the declaration [3.5 Marks] 2. Get the value of Product id from the user and calculate the new Product Price as per given criteria. Display Product Name with new calculated Price. [ 4 Marks] Company Toshiba HP Fujitsu Increment of Product Price 10% increase 20% increase 30% increase 3. Display this given series using while loop [2.5 Marks] 8 12 16 20 24 28