1-Create a stored Procedure DISP_OWNER_YOURFIRSTNAMELASTNAME (E.G. DISP_OWNER_JIAOWANG) . 

• This sP takes a single parameter/variable named I_PROPERTY_ID to store user input value of a PROPERTY ID.
• It should output OFFICE_NUM, ADDRESS, OWNER_NUM and OWNER_NAME (concatenated First Nˉ ame LastName in proper format)
• from the PROPERTY and OWNER tables for the given PROPERTY ID

2-Create a Stored Procedure UPDATE_OWNER_YOURFIRSTNAMELASTNAME (E.G. UPDATE_OWNER JIAOWANG) . 

• This Stored Procedure takes 2 parameters/variables:
• I_OWNER_NUM to store user input value of a OWNER_NUM, and I_LAST_NAME to store user input value of a new LAST_NAME.
• This stored procedure should update/change the last name to the given value, for the given owner num.

Answer rating: 100% (QA)

CREATE OR REPLACE PROCEDURE DISPOWNERYOURFIRSTNAMELASTNAME IPROPERTYID IN NUMBER IS OFFICENUM PROPERTYOFFICENUMTYPE ADDRESS PROPERTYADDRESSTYPE OWNERN... View the full answer