Explore BrainMass
Share

Explore BrainMass

    PL/SQL package

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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
    https://brainmass.com/computer-science/java/pl-sql-package-256539

    Attachments

    Solution Preview

    Please check attachment.

    Creation of Menu
    create or replace type MENU as object
    (
    home varchar2(56),
    movie varchar2(25),
    movie_stock varchar2(10)
    );
    Creation of SubMenu
    create or replace type MENU1 as object
    (
    movie_id number(10),
    movie_name varchar2(25),
    movie_price float(10,2)
    new_movie varchar2(50),
    );

    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. ...

    Solution Summary

    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.

    $2.19