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

1 Expert Approved Answer
Step: 1 Unlock

Heres a PLSQL block that fulfills your requirements including a constant variable a cursor to select ... View full answer

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!