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 is the difference between a primary key and a clustered index?
What is asqueryable?
What is oracle pl sql developer?
What is constant in pl sql?
Explain isolation levels. : Transact sql
What is the difference between microsoft sql and mysql?
What is case function?
What are tables in sql?
How do I sort a table in sql?
Give the order of sql select?
What version is sql?
What is the use of count (*) in sql?
What is scalar function in sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)