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.

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

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