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
- 11499 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 are the features of pl sql?
What is the importance of sqlcode and sqlerrm?
What is nvarchar in sql?
What is pragma in sql?
what is oracle database ? : Sql dba
What is a primary key example?
How to read/write files from pl/sql?
what is meant by urlencode and urldocode? : Sql dba
What is the use of index in sql?
How to handle bulk data?
How do I find duplicates in two columns?
What is dcl in sql?
What is the usage of sql functions?
Define the select into statement.
Cite the differences between execution of triggers and stored procedures?
