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

Classification of zoonoses disease , Classification of zoonoses More t...

Classification of zoonoses More than 300 zoonoses of diverse etiologies are recognized. Thus, a very large number of zoonoses call for classification, especially for teaching

Define major structures of chloroplasts, Q. What are the major structures o...

Q. What are the major structures of chloroplasts? Chloroplasts are involved by two membrane layers the inner and the outer membranes. Inside the organelle the formative unit is

Explain the body tube of microscope, Explain the Body Tube of Microscope? ...

Explain the Body Tube of Microscope? Above the stage and attached to the arm is the body tube, to which eye piece(s) or ocular lens and revolving nosepiece is attached. Microsc

Contemporary interests in nutritional biochemistry, Contemporary Interests ...

Contemporary Interests in Nutritional Biochemistry As  newer techniques in biochemistry have emerged from time to time, these were of immense help  in  the  understanding of ut

Biota of pelagic zone, Biota of Pelagic Zone Pelagic region constitute...

Biota of Pelagic Zone Pelagic region constitutes 90 per cent of the total ocean surface and is less rich in species and numbers of organisms than the two regions discussed bef

Point out research findings related to cancer prevention, Point out Researc...

Point out Research Findings Related to Cancer Prevention? In this section we shall discuss some of the research findings related to cancer prevention. Many of the natural, canc

Hiatus hernia, Hiatus Hernia: In  this type of hernia, cardiac end of ...

Hiatus Hernia: In  this type of hernia, cardiac end of  the stomach passes through an abnormally wide oesophageal opening in the diaphragm  (see Fig. 2.6). Clinical manifestat

Blood sampling , BLOOD SAMPLING : In blood sampling, the skin is deliberat...

BLOOD SAMPLING : In blood sampling, the skin is deliberately punctured in order to take a blood sample for analysis. If this is done carelessly, it is easy for microorganisms eith

Explain about the infantile beriberi, Explain about the Infantile beriberi?...

Explain about the Infantile beriberi? Infantile beriberi is commonly seen in many South-East Asian countries where the diets consist mostly of "polished rice" and are deficient

Estimation of burn area, Estimation of Burn Area: The  estimation of  ...

Estimation of Burn Area: The  estimation of  the  extent  of  burn area expressed as  the  percentage  of  the surface  area  of  the skin  burnt to  the  total body  surface

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