Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEADM\adm_env_sqlwrkshp.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>Configuring SQL Workshop</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:6:25Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Configuring SQL Workshop" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12512-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.htm" title="Home" type="text/html" /> <link rel="up" href="adm_wrkspc.htm" title="Oracle Application Express ..." type="text/html" /> <link rel="up" href="adm_env.htm" title="Managing Environment Settings" type="text/html" /> <link rel="up" href="adm_env_sqlwrkshp.htm" title="Configuring SQL Workshop" type="text/html" /> <link rel="prev" href="adm_env_demos.htm" title="Previous" type="text/html" /> <link rel="next" href="adm_env_monitor.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="adm_wrkspc.htm" title="Oracle Application Express ...">Oracle Application Express ...</a> > <a href="adm_env.htm" title="Managing Environment Settings">Managing Environment Settings</a> > Configuring SQL Workshop</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="adm_env_demos.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="adm_env_monitor.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CIHECJIC" name="CIHECJIC"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="AEADM198" id="AEADM198"></a>Configuring SQL Workshop<a id="sthref177" name="sthref177"></a><a id="sthref178" name="sthref178"></a></h1> <p>As an Oracle Application Express administrator, you can use the attributes under SQL Workshop to configure basic SQL Workshop behavior.</p> <p>To configure SQL Workshop:</p> <ol> <li> <p>Log in to Oracle Application Express Administration Services. See <a href="adm_login.htm#CHDHCIFG">"Logging in to Oracle Application Express Administration Services"</a>.</p> </li> <li> <p>Click <span class="bold">Manage Service</span>.</p> </li> <li> <p>Under Manage Environment Settings, click <span class="bold">Feature Configuration</span>.</p> </li> <li> <p>Under SQL Workshop, enter the attributes described in <a href="#CIHBBDFG">Table: SQL Workshop Attributes</a>.</p> <div class="tblformal"><a id="sthref179" name="sthref179"></a><a id="CIHBBDFG" name="CIHBBDFG"></a> <p class="titleintable">SQL Workshop Attributes</p> <table class="Formal" title="SQL Workshop Attributes" summary="This table describes the attributes available under SQL Workshop of the Manage Environment Preferences page." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="33%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t21">Attribute</th> <th align="left" valign="bottom" id="r1c2-t21">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t21" headers="r1c1-t21"> <p>SQL Commands Maximum Inactivity in minutes</p> </td> <td align="left" headers="r2c1-t21 r1c2-t21"> <p>Identify the maximum amount of time a transactional command in the SQL Command Processor waits before timing out.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t21" headers="r1c1-t21"> <p>SQL Scripts Maximum Script Output Size in bytes</p> </td> <td align="left" headers="r3c1-t21 r1c2-t21"> <p>Identify the maximum amount of output a single SQL script can generate. SQL scripts are run from the SQL Workshop.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t21" headers="r1c1-t21"> <p>SQL Scripts Maximum Workspace Output Size in bytes</p> </td> <td align="left" headers="r4c1-t21 r1c2-t21"> <p>Identify the maximum amount of space all scripts within a workspace may consume. SQL script results are the output generated when running SQL scripts from the Script Editor or from the SQL Scripts home page.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t21" headers="r1c1-t21"> <p>SQL Scripts Maximum Script Size in bytes</p> </td> <td align="left" headers="r5c1-t21 r1c2-t21"> <p>Identify the maximum size of a SQL script used within the SQL Workshop.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t21" headers="r1c1-t21"> <p>Enable Transactional SQL Commands</p> </td> <td align="left" headers="r6c1-t21 r1c2-t21"> <p>Select <span class="bold">Yes</span> to enable transactional SQL commands for the entire Oracle Application Express instance. Enabling this feature permits SQL Command Processor users to issue multiple SQL commands within the same physical database transaction.</p> <p>When you select <span class="bold">Yes</span>, an Autocommit check box appears on the SQL Command Processor page. By default, this option is set to <span class="bold">No</span>.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></li> <li> <p>Click <span class="bold">Apply Changes</span>.</p> </li> </ol> </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="adm_env_demos.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="adm_env_monitor.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