Answer Posted / roopesh kumar
We can directly handle them in exception section need not
to declare them. We need to declare them onle in case when
we want to put user friendly message instead of oracle's
default one.
Note: When others should be handle in last of exception
handling part of block.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between partitioning and sharding?
Why self join is used in sql?
Can we join same table in sql?
What is dcl in sql?
How do you know if a relationship is 2nf?
what is uncommittable transactions? : Transact sql
What is difference between left and right outer join?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is sql and explain its components?
what are all types of user defined functions? : Sql dba
how to extract a unit value from a date and time? : Sql dba
What is a variable in sql?
Name the operator which is used in the query for pattern matching?
What do you understand by pl/sql records?
How can we make an if statement within a select statement?