Explain the types of Exceptions

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.

User-defined exceptions
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
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?.......
How exceptions are raised in oracle?
How exceptions are raised in oracle? - Internal exceptions are raised implicitly by the run-time system. However, user-defined exceptions must be raised explicitly by RAISE statements....
What are conversion functions?
CHARTOROWID, CONVERT, HEXTORAW, RAWTOHEX, ROWIDTOCHAR, TO_CHAR, TO_DATE, TO_NUMBER.....
Post your comment