How the execution will be done in exceptions?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swapna
We use exceptions to check the status of our procs .. like
what to do if the things are not going smoothly as
expected . ie we insert errors in audit tables with
user,date-time,err code.
Is This Answer Correct ? | 1 Yes | 0 No |
how to create a table index in mysql? : Sql dba
If a View on a single base table is manipulated will the changes be reflected on the base table?
What does select * from mean in sql?
using subquery how can i calculate working days in a month?
Is sql microsoft?
Can we connect to postgresql using sql developer?
what is the use of set statement in tsql? : Transact sql
What is the diff between Truncate table / delete <table name> purge
Does a join table need a primary key?
How to get employee name from employee table which is the fiveth highest salary of the table
Why indexing is needed?
How to revise and re-run the last sql command?