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
- 11854 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 java sql driver?
What does count (*) mean?
how can we find the number of rows in a table using mysql? : Sql dba
What is recursive stored procedure?
What is AUTH_ID and AUTH_USER in pl/sql ?
what are date and time functions in mysql? : Sql dba
Are stored procedures faster than dynamic sql?
Is sql a oracle?
What is dml with example?
What are % type and % rowtype?
Is trigger a stored procedure?
Explain the difference between drop and truncate commands in sql?
What is the difference between count 1 and count (*) in a sql query?
How many types of normalization are there?
What does varchar include?
