Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh kumar somayajula
Raising an error in PL/SQL execution block is nothing
but "Execption". These are of 2 types.
1.Predefined Exception 2. User defined Exception
Total 19+1 predefined exceptions are there.
19+1 means 19+When Others.
"When others" is the last one.After "When Others" no
exception will be raised.
Eg. for Predefined Exceptions:
No_data_found,Dup_val_on_index,Invalid_cursor,Invalid_number
,Zero_Divide,.......,'When Others'..
Thank you,
Suresh.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How do I add a primary key to a table?
What are different types of sql?
What is the difference between delete and truncate statement in sql?
How many types of tables are there?
What is sql select statement?
What is a scalar value in sql?
How to fetch alternate records from a table?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is difference between table and view?
How can you tell the difference between an index and a view?
What is the example of procedure?
where are cookies actually stored on the hard disk? : Sql dba
What is range partitioning?
Can we write dml inside a function in sql server?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
