Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
10 Point. Using the Solmaris Condominium Group Database make a stored procedure that will display the first name and last name of an owner when an...
1. 10 Point. Using the Solmaris Condominium Group Database make a stored procedure that will display the first name and last name of an owner when an owner's number is passed to it. Use owner 'AN175' for this project but your procedure should return any owner's name if the correct owner number is provided.
A. Provide text of the procedure so I can copy and paste it into Oracle to test.
B. Provide a screen capture of the procedure being created.
C. Provide a screen capture of the procedure's output.
2. 15 Points. Using the Solmaris Condominium Group Database make a stored procedure that will display a list of all Unit_Num and Condo_Fee from the condo_unit table. Make sure to include some space between the fields when they are displayed.
A. Provide text of the procedure so I can copy and paste it into Oracle to test.
B. Provide a screen capture of the procedure being created.
C. Provide a screen capture of the procedure's output.
