Question: 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
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 variable once your block is working to test your code. Declare any other constructs needed to complete the specifics of the instructions below. Using the given amount in the above variable, create a cursor that will select all employees whose salary is greater than the value of that variable. Include the last name, department name, and salary so you can produce the following message: (items highlighted are dynamic) Process the rows in order by department name, then employee last name. Highlighted text is dynamic. Add exception handling that will display the current error for any exception that may be raised.
Step by Step Solution
There are 3 Steps involved in it
Heres a PLSQL block that fulfills your requirements including a constant variable a cursor to select ... View full answer
Get step-by-step solutions from verified subject matter experts
