Explain the types of Exceptions.Predefined oracle exceptions
These are the PL/SQL runtime engine raised named system exceptions. These exceptions are raised automatically by the program. You cannot control when PL/SQL will raise a system exception.
These are programmer raised named exceptions. The programmer can use an explicit call to the RAISE statement to raise a programmer-defined or system-named exception. The programmer can also raise unnamed, programmer-defined exceptions and re-raised "current" exceptions.
Oracle Exceptions - Define Exceptions in PL/SQL, Explain how to define and raise exceptions in PL/SQL, What is Pragma Init Exception in oracle?, How exceptions are raised in oracle?.......