types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
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
what are set operators in sql? : Sql dba
How do you sort in sql?
What is the use of %rowtype?
How to add new employee details in an employee_details table with the following details
Can we use insert statement in function?
What is input buffer in sql*plus?
What is sharding in sql?
Is sql easier than java?
How bulk collect improves performance?
Mention what does plv msg allows you to do?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
Why do we create views in sql?
What is sql query limit?
What is the use of stored procedures?
What is a sql*loader control file?