Question: please i need help with this pl/sql program Run the script, C1_MMcreate.sql, to create the tables required for this lab. The Moore Movie Rentals receives

please i need help with this pl/sql program

Run the script, C1_MMcreate.sql, to create the tables required for this lab. The Moore Movie Rentals receives numerous requests to check whether movies are in stock. The company needs a function that retrieves movie stock information and formats a clear message to display to users requesting the information. The display returned by the function should look like the following: Star Wars is Available: 11 on the shelf Or Star Wars is Not Available: Use the Movie ID field as the input value for this function. Assume the MOVIE_QTY column in the MM_MOVIES table indicate the number of movies currently available for check out. Do not use the DBMS_OUTPUT.PUT_LINE procedure in the function. Test the function with an anonymous block using the Movie IDs: 2, 3, and 20.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

This practice lab provides you the opportunity to create tables, primary keys and foreign keys with the use of SQL commands. The lab will utilize the FLIX2YOU problem. (In Microsoft SQL studio) In...

This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you must have...

And Below is the script provided /* Modifications: (1) Removed DELETE FROM and RESEED commands from script; 1/3/13 by glh */ /* PLEASE READ THE INSTRUCTIONS FOR LAB # 7 BEFORE EXECUTING */ /* Insert...

Lab 7: Inserting and Updating Data OVERVIEW This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current...

This practice lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab, you...

Can anyone please help me out about this lab? What I have to do is LAB #7. I have done lab #6. Upon completion of the previous lab (lab #6), all 14 tables should exist in your folder schema in VLABS...

SQL--OVERVIEW This lab provides you the opportunity to insert and update data with the use of SQL commands. The lab will utilize the FLIX2YOU problem, the current schema. In order to start this lab,...

In order to start this lab, you must have successfully completed Lab #6. In Lab #6, you executed a script that was provided to you. This script created 7 of the FLIX2YOU tables as documented in the...

Overview The purpose of this part of the project is to make sure that you know how to write a program that declare and use classes and objects, and extends the practice into the use of arrays of...

May 5 Purchased 800 shares of its own 2 par value common stock for 208 per share the current market price 17 Sold 400 shares of treasury stock purchased on May 5 for 22 per share 21 Sold 200 shares...

a. What are the decision alternatives? b. What are the possible states of nature? Hartsfield International Airport in Atlanta, Georgia, is one of the busiest airports in the world. Plans are being...

Integral of 1 / ( 1 [ x 1 ] ^ . 5 )

You are trying to estimate the value of a property that you are interested in buying. The subject property is located at 322 Rock Creek Road in a new suburb of a large metropolitan area. The property...

Develop clear, concise, logical, coherent, and effective paragraphs.

Identify words that your receiver(s) will understand and that will elicit the intended response.

Describe ethical considerations for communication, and explain how codes of conduct help organizations promote ethical business behavior.