Write a pl-sql block to select the name of the employee

Assignment Help PL-SQL Programming

Reference no: EM13774960

Write a PL/SQL block to select the name of the employee with a given salary value. You will be using the MESSAGES table that was created for a previous assignment.

Declare a variable of type emp.sal as a salary variable and assign the value 800 to that variable.

If the salary entered returns more than one row, handle the exception with an appropriate exception handler and insert into the MESSAGES table the message "More than one employee with a salary of <salary>."

If the salary entered does not return any rows, handle the exception with an appropriate exception handler and insert into the MESSAGES table the message "No employee with a salary of <salary>."

If the salary entered returns only one row, insert into the MESSAGES table the employee's name and the salary amount.

Handle any other exception with an appropriate exception handler and insert into the MESSAGES table the message "Some other error occurred."

Before you run your SQL run the following SQL statement:

delete from messages;

Observe the output similar to the following results:

9 row(s) deleted.

Reference no: EM13774960

Questions Cloud

Compromises help benefit the during divorce process : Write a 350- to 500-word paper describing any practical compromises you would recommend and how these compromises help benefit the following during the divorce process:

Typical state court system : Write a memo ona state (not federal) level business dispute. Describeas if you were writing a "white paper" for your boss who wants to know how a case like the one you have chosen would be processed throughout the various legal phases in a state ..

Write an argument reaserch paper about bad use of facebook : Write an argument reaserch paper about "bad use of facebook"

Organizations and public agencies address issue of ethics : For this Discussion topic, you are first asked to identify three (3) peer-reviewed academic journal articles from the internet that analyze and evaluate how organizations and public agencies address the issue of ethics.

Write a pl-sql block to select the name of the employee : Write a PL/SQL block to select the name of the employee with a given salary value. You will be using the MESSAGES table that was created for a previous assignment.

Incarceration or detention for juvenile offenders : Use the Internet or Strayer databases to research the use of sanctions other than incarceration or detention for juvenile offenders.

Situations depending on the punctured drum : What information are you after, how do you gather it, and what instructions do you provide for your team?

Calculate the quantity of heat absorbed : Explain why you placed the watch glass over the evaporating dish in the salt-recovery set-up and explain why you needed to cool the recovered sand and salt to room temperature before determining their masses.

Scope and consequences of the issue : Describe the scope and consequences of the issue, and discuss society's responses to the issue (including public policies and other less formal responses). Papers should also present a clearly reasoned alternative, supported by scholarly research.

User Account

All Pages