What is an Exception ? What are types of Exception ?
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 does select top 1 do in sql?
How do I count rows in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Can we edit a view in sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
Write a sql query to convert all character to uppercase after hypen.
How to run sql*plus commands in sql developer?
What is sqlservr exe?
What is server name sql?
What is the need of merge statement?
What are aggregate and scalar functions?
how many values can the set function of mysql take? : Sql dba
What do you know by pl/sql cursors?
What is a unique key and primary key and foreign key?
What is partition by in sql?