Interested to Buy Any Domain ? << Click Here >> for more details...
types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
- 4 Answers
- 11725 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / suresh babu
Two types of exceptions used in oracle.
1.Predefined exceptions,which defined by oracle
already.Ex-NO_DATA_FOUND,DIVIDE_BY_ZERO,etc...
2.User defined exceptions,which defined by the user based on
their application requirement.
pragma autonomous_transaction is an independent
transaction.Once we issue commit,we cannot rollback except
the block,where we mentioned autonomous_transaction.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do you explain an index number?
How to select all records from the table?
Can variables be used in sql statements?
What are the steps for performance tuning.
Is stored procedure faster than query?
How to set up sql*plus output format in oracle?
Enlist the advantages of sql.
How do I order columns in sql?
What is sqlerrd?
What is the difference between syntax error and runtime error?
Explain the working of foreign key?
Can we call a function containing dml statements in a select query?
How do temporal tables work?
What is a full join sql?
What are inner outer left and right joins in sql?
