Interested to Buy Any Domain ? << Click Here >> for more details...
what is the order of pre-defined exceptions.
- 6 Answers
- 16731 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajadurai r
There are 20 pre-defined exceptions.
When an exception is raised,normal execution of your PL/SQL
block or subprograms stops and control transfers to its
exception-handling part.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rahul khanke
pre defined exception u should not have to declare in
declare section
ex. dul_value_error
when_duplicate_row
etc
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / chandra shekher
User Defined exceptions are executed prior to system
defined exceptions.
User defined exceptions are executed in the order in which
they are defined.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / avi007
order of preddfined exceptions is to first catch the
exception in begin end; block
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / suresh somayajula
In these we will use 19+1 exceptions.
it means " When Others " is the last exception in
pl/sql block.execution will be end at When Others exception
Stmt.
suresh.
suresh.somayajula@gmail.com
| Is This Answer Correct ? | 0 Yes | 1 No |
How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.
How to recompile a already made trigger?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What are user defined stored procedures ?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is anonymous block in sql?
what is foreign key? : Sql dba
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is a procedure in pl sql?
in procedure how to return a value
What is the Subquery?
explain normalization concept? : Sql dba
-
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)
