types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
- 4 Answers
- 10685 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
What is a schema sql?
What is the difference between delete and truncate statement in sql?
What is sql entity?
What is an inconsistent dependency?
How to rename a column in the output of sql query?
How do you remove duplicates without using distinct in sql?
Explain the insert into statements in sql?
How to download oracle sql developer?
what are the type of locks ? : Sql dba
What pl/sql package consists of?
Explain autonomous transaction.
What type of database is cloud sql?
What is use of package in pl sql?
Do foreign keys improve performance?
How do I view a table in sql?
