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

Characteristic of ecotone, Characteristic of Ecotone A general charact...

Characteristic of Ecotone A general characteristic of ecotone is that it has sufficiently greater number of species and the diversity of most of the species at times is higher

Phases of ovarian cycle, Phases of Ovarian Cycle In non-mammalian vert...

Phases of Ovarian Cycle In non-mammalian vertebrates the ovarian cycle consists of the following phase; Pre breeding phase Breeding phase and Post breedin

Right coronary artery, Right coronary artery arises from the anterior aorti...

Right coronary artery arises from the anterior aortic sinus. It runs down along the anterior part of the coronary sulcus, reaches the lower border of heart turns round the lower bo

Define about the micro minerals, Define about the Micro Minerals? Micro...

Define about the Micro Minerals? Micro minerals are those minerals, which comprise less than 0.01% of the total body weight and are required in concentrations of one part per m

What is the meaning of term - plasticity, What is the meaning of term - Pla...

What is the meaning of term - Plasticity The notion of brain plasticity has been of interest to researchers and clinicians alike for decades. The outcome of injury is the resul

Viral genome, describe the different types of genomes that viruses can have...

describe the different types of genomes that viruses can have

Explain the radiographic success of root canal treatment, Explain the Radio...

Explain the Radiographic Success of Root Canal Treatment Elimination or lack of development of an area of rarefaction (= Radiolocency )  for a minimum of I year after treatment

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