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
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the use of index in sql?
What are analytical functions in sql?
what are set operators in sql? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is procedure explain with example?
what is the stuff function and how does it differ from the replace function? : Sql dba
what is normalization? : Sql dba
Can you have a foreign key without a primary key?
Why schema is used in sql?
how to drop an existing view in mysql? : Sql dba
what is text? : Sql dba
What is the difference between Union and Union all. Which is faster.
Explain two easy sql optimizations.
What is cursor in pl sql with examples?