Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Exception ? What are types of Exception ?
- 2 Answers
- 7207 Views
- I also Faced
- E-Mail Answers
Answer Posted / chintu
Any ubnormal event in a program is called Exception.
In pl/ sql there are two types of exceptions they are
Userdefind Exception and predefined Exceptions.
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.
user defined exceptions are defined by raise_application_
error("error msg","error number") and
pragma_exception_init()
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What company owns postgresql?
how can we know the number of days between two given dates using mysql? : Sql dba
Is a foreign key always unique?
what is a field in a database ? : Sql dba
what are all different types of collation sensitivity? : Sql dba
Why do we need databases?
What is partition by in sql?
How many primary keys can a table have?
Why are aggregate functions called so?
What is the difference between distinct and unique in sql?
who introduced sql?
What is insert command in sql?
What is trigger price?
Differentiate between sga and pga.
How to start the command-line sql*plus?
