Purchase Solution

PL/SQL package

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

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.

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 provided by:
Education
  • BCom, SGTB Khalsa College, University of Delhi
  • MBA, Rochester Institute of Technology
Recent Feedback
  • "Thank you. "
  • "Thank you"
  • "Thank you. I got 20/20 last week for my discussion you help me out with."
  • "Thank you. Great Job. "
  • "Thank you. Great Job. "
Purchase this Solution


Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C++ Operators

This quiz tests a student's knowledge about C++ operators.