PL/SQL: Exception Handling

·         Exception Handling.

·         Trapping Exceptions.

· The Others Exception Handler and Exception Guidelines. 

·         Types of Exceptions.

·         Predefined Exception.

·         User-defined Exception.

·         Using a packaged procedure.

·  Write a PL/SQL Program to hike the employee salary as 35% if entered employee salary not less than(<) 2000. If salary is less than(<) 2000 display the message and suspend the program process.

· Write a PL/SQL Program to hike the i.Employee salary as 35% if employee having a salary. ii.If employee not having a salary rise the user exception and give the salary 3000.

· Trapping Non-Predefined oracle server errors.