changes and the price must be updated from to time. Your supervisor
requests you to create a procedure that will update the property
price for all affected properties which has been increased or
reduced by the homeowners.
Write PL/SQL to
create a stored procedure name
PropertyPriceUpdate.
This stored procedure will:
Sample output of the
procedure is shown below in Figure Q3a. (Use your pen to
write the statement in your answer scripts)
- The Properties Experiencing Price Changes And The Price Must Be Updated From To Time Your Supervisor Requests You To Cr 1 (28.53 KiB) Viewed 14 times
Your supervisor handed to you a list of properties (Table
Q3b) that have price changes.
Table Q3b
List of updated property prices
propertyCode
Price
New Price
PR20
RM250,000
RM200,000.00
PR21
RM570,000
RM575,000.00
PR22
RM330,000
RM400,000.00
Write THREE (3)
EXECUTE statements to update the THREE (3)
different properties in Table Q3b. (Use your pen to write
the statement in your answer scripts)
Property Code = P201 |New Price = 260000