Answer Posted / madhuri
Execution is exception is done in many ways.
An exception occurs when there is something wrong in the
code of pl/sql block.
Exception can be raised either in declarative,executable or
in exception section itself.
In case of nested blocks when an exception occurs in inner
block,it will try to find its handle in the same block,if
not then control comes out of inner block and executes the
handler in the outer block.
When exception occurs in declarative and exception
section,then control is propagated to the next outer block.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is sql similar to python?
what is column? : Sql dba
does sql support programming? : Sql dba
How can you tell the difference between an index and a view?
How to fix oracle error ora-00942: table or view does not exist
What is difference between sql and oracle?
how to create a test table in your mysql server? : Sql dba
Is natural join same as inner join?
How do you declare a constant?
What are triggers in sql?
What is the difference between a primary key and a clustered index?
Why coalesce is used in sql?
Does sqlite need a server?
What are the most important ddl statements in sql?
What is sql analyzer?