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
What are types of joins?
Enlist the characteristics of pl/sql?
How do I run sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is rownum and rowid?
Write an sql query to select all records from the table?
Explain the uses of database trigger.
what is oltp (online transaction processing)? : Sql dba
What does the sign mean in sql?
How do I find duplicates in a single column in sql?
Is left join same as inner join?
How do you modify a trigger?
how to calculate expressions with sql statements? : Sql dba
What is using in sql?
What is the usage of distinct keyword?
