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 the procedure of uristix, What is the Procedure of Uristix 1. C...

What is the Procedure of Uristix 1. Collect the urine. 2. Remove one strip from bottle and replace cap. 3. Completely immerse reagent areas of the strip in urine and remo

Explain about non-surgical therapy, Non-Surgical Therapy The most conse...

Non-Surgical Therapy The most conservative approach to treatment involves non-surgical therapy. This treatment modality includes three subcategories: a) Pharmacological ther

Define the neurological disorders of dysphagia, Define the neurological dis...

Define the neurological disorders of dysphagia? In neurological disorders, damage to cranial nerves can lead to weak and poorly co- ordinated tongue movements, which results in

Effects of insulin on carbohydrate metabolism, Insulin promotes muscle gluc...

Insulin promotes muscle glucose uptake and metabolism. In presence of insulin muscle cells take up glucose and use it as a source of energy. Insulin also promotes storage of insuli

What are the advantages of intra oral periapical radiographs, Advantages of...

Advantages of Intra Oral Periapical Radiographs a) It is a useful high yield modality for ruling out local bone or dental disease b)  It is of value in identifying critical

Biotechnology in characterization of animal biodiversity, Use of biotechnol...

Use of biotechnology in characterization of animal biodiversity. Genetic uniqueness of populations is measured by the relative genetic distances of such populations from each o

Explain the importance of nicotinic acid, Explain the Importance of nicotin...

Explain the Importance of nicotinic acid Nicotinic acid is successfully used in the therapy of a number of vascular disorders such as vascular spasms, angina pectoris, arthriti

What are the autotrophic beings called, In the ecological study of food int...

In the ecological study of food interactions, what are the autotrophic beings called? In the Ecology autotrophic beings are called as producers because they synthesize the orga

Phylum protozoa, Classification of the phylum protozoa

Classification of the phylum protozoa

Zoology, general characteristics of phylum chordata

general characteristics of phylum chordata

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