Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEUTL\sql_proc_trans.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>About Transactions in SQL Commands</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:10:1Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Transactions in SQL Commands" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12511-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="sql_proc.htm" title="Using SQL Commands" type="text/html" /> <link rel="up" href="sql_proc_execute.htm" title="Using the Command Editor" type="text/html" /> <link rel="up" href="sql_proc_trans.htm" title="About Transactions in SQL C..." type="text/html" /> <link rel="prev" href="sql_proc_run.htm" title="Previous" type="text/html" /> <link rel="next" href="sql_proc_unsupport.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="sql_proc.htm" title="Using SQL Commands">Using SQL Commands</a> > <a href="sql_proc_execute.htm" title="Using the Command Editor">Using the Command Editor</a> > About Transactions in SQL C...</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="sql_proc_run.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_proc_unsupport.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BABDBJDG" name="BABDBJDG"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEUTL225" id="AEUTL225"></a>About Transactions<a id="sthref229" name="sthref229"></a><a id="sthref230" name="sthref230"></a> in SQL Commands</h1> <p>To disable transactional SQL commands in SQL Commands, check the Autocommit check box. Attempting to use any transactional SQL commands such as COMMIT or ROLLBACK when transactional mode is disabled returns an error message.</p> <p>To enable transactional SQL commands, clear the Autocommit check box. Oracle Application Express verifies that the necessary system resources are available before entering the transactional mode. If resources are unavailable, an error message is displayed.</p> <p>Transactional mode is a stateful transaction mode where you can, for example, perform an update, select data for review, and COMMIT or ROLLBACK changes. It is implemented using DBMS_JOBS.</p> <p>Consider the following behavior in transactional mode:</p> <ul> <li> <p>Actions are not committed to the database until you enter an explicit COMMIT command.</p> </li> <li> <p>Exiting SQL Commands terminates and rolls back the current transaction.</p> </li> <li> <p>A session timeout terminates and rolls back the current transaction.</p> <p>Note that the Environment Setting, <code>SQL Commands Maximum Inactivity in minutes</code>, sets the time before an inactive session times out. The default timeout is 60 minutes. See <a href="../AEADM/adm_env.htm">"Configuring SQL Workshop"</a> in <a href="../AEADM/preface.htm"><span class="italic">Oracle Application Express Administration Guide</span></a>.</p> </li> <li> <p>The <span class="bold">CSV Export</span> option is not available.</p> </li> </ul> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="sql_proc_run.htm#CHDJBCCH">"Running a SQL Command"</a>, <a href="sql_proc_unsupport.htm#BABHADFA">"About Unsupported SQL*Plus Commands"</a>, <a href="sql_proc_term.htm#CHDBHGFD">"About Command Termination"</a>, and <a href="sql_proc_bind.htm#CHDBIIJJ">"Using Bind Variables"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="sql_proc_run.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="sql_proc_unsupport.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de