Using autonomous transactions, Biology

Assignment Help:

Using Autonomous Transactions 

The transaction is a sequence of SQL statements that does a logical unit of work. Frequently, one transaction starts the other. In several applications, a transaction should operate outside the scope of the transaction that executed it. This can happen, for e.g. If a transaction calls out to a data cartridge.

An autonomous transaction is an independent transaction started by the other transaction, the main transaction. The Autonomous transactions suspend the main transaction, to do the SQL operations, commit or roll back these operations, and then resume the major transaction.

1415_autonomous transaction flow.png

Figure: Transaction Control Flow


Related Discussions:- Using autonomous transactions

What is a terrestrial organism, Explain what is a terrestrial organism? ...

Explain what is a terrestrial organism? Ans) 'Terra' is the Latin word for earth. Thus, an animal that lives on the surface of the earth is known as terrestrial. This is the si

What are the euchromatin and heterochromatin, Q. What are the euchromatin a...

Q. What are the euchromatin and heterochromatin? Chromatin is uncondensed nuclear the DNA the typical DNA morphology in interphase the phase of the cell cycle in which the cell

What are some common laboratory techniques, What are some common laboratory...

What are some common laboratory techniques? During the course of these laboratory sessions, you will be usual to become proficient in the performance of the following laborator

Zoonoses disease-cryptococcosis, Cryptococcosis An opportunistic infect...

Cryptococcosis An opportunistic infection, caused by Cryptococcus neoformans is affecting immunocompromised individuals mainly with impaired cell mediated immunity. The disease

Growth at different levels, GROWTH AT DIFFERENT LEVELS - 1.      Molec...

GROWTH AT DIFFERENT LEVELS - 1.      Molecular level - It involves synthesis of new molecules and their aggregation into organellae. 2.      Cellular level - It includes

What do you mean by biodigester, Q. What do you mean by biodigester? A ...

Q. What do you mean by biodigester? A biodigester is equipment that produces hydrogen sulfide, carbon dioxide and fuel gases (biogases) like methane from organic material under

Tapetum - anther wall layers, Tapetum - Anther Wall Layers Tapetum is ...

Tapetum - Anther Wall Layers Tapetum is the innermost and most important layer of the anther wall. It is generally composed of a single layer of cells. These cells completely

Explain disease jet lag, Jet Lag   Disturbance of body and environmental...

Jet Lag   Disturbance of body and environmental rhythms resulting from a rapid change in time zones gives rise to jet lag, which is characterized by insomnia, decreased quality

Plant physiology.., why does the removal of the extremity of coleoptile pro...

why does the removal of the extremity of coleoptile prohibit plant growth?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd