Question: Write a PL/SQL block to produce a list of available numbers. These numbers must be in the following format: NNN-MM, where NNN is between 120

Write a PL/SQL block to produce a list of available numbers. These numbers must be in the following format: *NNN-MM*, where NNN is between 120 and 125, and MM is between 50 and 55. Use nested loops. The outer loop should choose numbers between 120 and 125. The inner loop should choose numbers between 50 and 55, and concatenate the two numbers together in the format given above. Also, include your initials (initial of your first name and initial of your last name) when displaying the results. See the sample results below.

Available numbers are: 120-50 AA 120-51 AA 120-52 AA 120-53 AA 120-54 AA 120-55 AA 121-50 AA 121-51 AA 121-52

Available numbers are: 120-50 AA 120-51 AA 120-52 AA 120-53 AA 120-54 AA 120-55 AA 121-50 AA 121-51 AA 121-52 AA 121-53 AA 121-54 AA 121-55 AA 122-50 AA 122-51 AA 122-52 AA 122-53 AA 122-54 AA 122-55 AA 123-50 AA 123-51 AA 123-52 AA

Step by Step Solution

★★★★★

3.36 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

You can use PLSQL to generate the list of available number... View full answer

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!

Declare and assign these variables as shown (all your code must appear in the body of the main method): String firstName = "Blueberry"; String lastName = "Strawberry"; In addition, declare and...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

You will design and implement your own data class. The class will store data that has been read as user input from the keyboard (see Getting Input below), and provide necessary operations. As the...

4. Create a PL/SQL Block that selects customer details (Name & Address), Products ordered, Quantity ordered and total amount for all 'pending' orders of 2015. [Hint;- total amount can be calculated...

1. Write a PL/SQL block to ask the user to enter the students marks and determine the GRADE (using IF statements) according to the following criteria. Your output should display the following message...

D. Run a SELECT statement against the COUNTRIES table to determine whether the following countries have independence dates or national holiday dates, or both. Predict the output of running the...

Write a PL/SQL block with the following specifics: Create a variable that will be used to contain a salary amount. Make it a constant with an intital value of 10000. Try several values for this...

Q 2 . ( 2 0 points ) . Refer to page 3 in note 6 b _ Records. Define a user - defined record type called DEPT _ INFO that has four fields as: dept _ id ( correspondent to department _ id in...

Q 3 . ( 2 0 points ) Package, function returns a record type and function overloading. This question requires to use table Employees and Departments. In this question, you are required to create a...

You are a professor at the National University less data including student results table with student, Write a PL / SQL block to list students who got me test results provided in student result tibie...

For a normal population with a mean equal to 80 and a standard deviation equal to 15, determine the probability of observing a sample mean of 85 or less from a sample of size 10.

Section 404 of the Sarbanes-Oxley Act increased top managements responsibility for what?

Referring to the information concerning the MBA decision, what is the Present Value of the income associated with Brooke's present job?

Service industry, job costing, two direct- and two indirect-cost categories, law firm. Keating has just completed a review of its job-costing system. This review included a detailed analysis of how...

Job costing; actual, normal, and variation from normal costing. Chico & Partners, a Quebec-based public accounting partnership, specializes in audit services. Its job-costing system has a single...

Kretz Corporation prepares monthly financial statements and therefore adjusts its accounts at the end of every month. The following information is available for March 2010: a. Kretz Corporation takes...

The following information has been taken from the ledger accounts of Sampras Corporation. Total income since incorporation ...........$287,000 Total cash dividends paid ...............60,000 Total...

Lu Technology, Co., manufactures CDs and DVDs for computer software and entertainment companies. Lu uses job order costing and has a perpetual inventory system. On April 2, Lu began production of...

. External Analysis Mount Saint Vincent University Students will have to conduct an external analysis for Mount Saint Vincent University. Students should know the Mount and are expected to complete...

This will help hone your regex skills, as well as introduce some Internet-related and module-related things. Let's say that there was a particular section of a particular web page that you wanted...

Question 1 Write a PL/SQL block that allows the user to input his/her name and print it with the string "Your Name is: .'. Question 2 Write a PL/SQL block that allows the user to input a sub-total...

Iterative Control: WHILE and FOR Loops 1. Write a PL/SQL block to display the country_id and country_name values from the WF_COUNTRIES table for country_id whose values range from 51 through 55. Use...

Ques-2 Database Programming with PL/SQL 5-4: Cursors with Parameters Practice Activities Vocabulary No new vocabulary for this lesson Try It / Solve It 1. Describe the benefit of using one or more...

pie going to that t that will change the balance by giving a 10% discount to each customer going for a cruise. Check your statement 3) 4) 5) ustomer with the updated balance. Write a SQL statement to...

Q 4 . ( 1 5 points ) Note that Q 5 and Q 6 are based on this question Q 4 . Write a PL / SQL block, in that program, define a local procedure named Dept _ Head _ name. This procedure lives in that...

Question: Write a PL/SQL block to produce a list of available numbers. These numbers must be in the following format: *NNN-MM*, where NNN is between 120

Step by Step Solution

Students Have Also Explored These Related Databases Questions!

Question: Write a PL/SQL block to produce a list of available numbers. These numbers must be in the following format: NNN-MM, where NNN is between 120