Combine the work you've completed so far for the More Movie Rentals database into one program. Create a simple PL/SQL package in order to go through a menu process. In this PL/SQL package, all users would enter in a movie by executing a procedure. Be sure the validation works correctly. Include the proper exception handling and have the PL/SQL code throw any exceptions that are deemed necessary. Be sure to use a good naming scheme for the procedures and functions within this package.
attached is all the work completed for movie rentals© BrainMass Inc. brainmass.com October 9, 2019, 11:26 pm ad1c9bdddf
Please check attachment.
Creation of Menu
create or replace type MENU as object
Creation of SubMenu
create or replace type MENU1 as object
Starting and Quitting SQL*Menu (Design):
To start SQL*Menu (Design), enter the following at the operating system prompt (remember to start the xterm with -sf option).
sqlmenu50 / -c xtermsun:MENU
If you are denied access to SQL*Menu (Design) you should contact your SQL*Menu DBA (labadmin).
To exit from SQL*Menu (Design) select Action and then Quit. ...
Combine the work you've completed so far for the More Movie Rentals database into one program. Create a simple PL/SQL package in order to go through a menu process.