Oracle PL-SQL Question:
Download Questions PDF

What is an Exception? What are types of Exception?

Answer:

Exception is the error handling part of PL/SQL block. The types are Predefined and user defined. Some of Predefined exceptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

exception is an identifier and error handling part of pl/sql types := 1)predifined
2) user defined.

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Write the order of precedence for validation of a column in a table?
I. done using Database triggers.
ii. done using Integarity Constraints		What is Pragma EXECPTION_INIT? Explain the usage?