Interested to Buy Any Domain ? << Click Here >> for more details...
How the execution will be done in exceptions?
- 2 Answers
- 6996 Views
- I also Faced
- E-Mail Answers
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 |
Can we use ddl statements in stored procedure?
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
what are local and global variables and their differences? : Sql dba
How do I tune a sql query?
how to present a past time in hours, minutes and seconds? : Sql dba
What is the difference between sql, mysql and sql server?
What is the difference between clustered and non-clustered index in sql?
Does db2 use sql?
Why do we need sharding?
Can we create table in function?
With out using count() function. How to the find total number of rows in a table?
How to start the command-line sql*plus?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
