Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\concept_cond_process.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>Understanding Conditional Rendering and Processing</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:25Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Understanding Conditional Rendering and Processing" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11947-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="concept.htm" title="Application Builder Concepts" type="text/html" /> <link rel="up" href="concept_rndr.htm" title="Understanding Page Processi..." type="text/html" /> <link rel="up" href="concept_cond_process.htm" title="Understanding Conditional R..." type="text/html" /> <link rel="prev" href="concept_rendering.htm" title="Previous" type="text/html" /> <link rel="next" href="concept_user_id.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="concept.htm" title="Application Builder Concepts">Application Builder Concepts</a> > <a href="concept_rndr.htm" title="Understanding Page Processi...">Understanding Page Processi...</a> > Understanding Conditional R...</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="concept_rendering.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="concept_user_id.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="BEIEBEHI" name="BEIEBEHI"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB03004|Understanding Conditional Rendering and Processing"></a>Understanding Conditional Rendering and <a id="sthref147" name="sthref147"></a><a id="sthref148" name="sthref148"></a><a id="sthref149" name="sthref149"></a>Processing</h1> <p>A condition is a small unit of logic that helps you control the display of regions, items, buttons, and tabs as well as the execution of processes, computations, and validations. For example, when you apply a condition to a button, the rendering engine evaluates the condition during the rendering (or Show Page) process. Whether the condition passes or fails determines if the page control (such as a button) displays.</p> <p>You specify a condition by selecting a condition type. You can select a condition type when you first create the control or component, or by editing the control or component and making a selection from the Condition Type attribute. Depending upon the Condition Type you select, you enter the appropriate values in the Expressions fields. The condition evaluates to true or false based on the values you enter in the Expression fields.</p> <div align="center"> <div class="inftblnote"><br /> <table class="Note oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">Note:</p> Whether you use the Expression fields depends upon the selected condition type. Some condition types do not require values in either field, others require a value only for Expression 1, and other condition types require values in both fields. Although these fields are labeled "Expression 1" and "Expression 2", the values for a given condition type do not necessarily conform to any formal definition of the term <span class="bold">expression</span>. They are simply text values appropriate for the selected condition type.</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnote" --></div> <p>To view a complete list of all available conditions for a given component or control, click the arrow to the right of the Condition Type list. Shortcuts to common selections appear directly beneath the list. If your condition requires an expression, enter it in the appropriate field.</p> <p>The following sections offer examples of some commonly used <a id="sthref150" name="sthref150"></a>condition types.</p> <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="condition.htm#CJHJFDBA">Available Conditions</a> for a detailed listing of available condition types</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref151" name="sthref151"></a> <h2><a name="HTMDB25019" id="HTMDB25019"></a>Current Page in Expression 1</h2> <p><span class="bold">Current page in Expression 1</span> evaluates to true if the current page number is contained within the comma-delimited list of pages in Expression 1. For example:</p> <pre xml:space="preserve" class="oac_no_warn"> 3,100,203 </pre> <p>If the current page is 100, then this condition evaluates to true and the condition passes.</p> </div> <!-- class="sect3" --> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref152" name="sthref152"></a> <h2><a name="HTMDB25020" id="HTMDB25020"></a>Exists</h2> <p><span class="bold">Exists (SQL query returns at least one row)</span> is expressed as a SQL query. If the query returns at least one row, then the condition evaluates as true. For example:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT 1 FROM employees WHERE department_id = :P101_DEPTNO </pre> <p>This example references item <code>P101_DEPTNO</code> as a bind variable. You can use bind variables within application processes and SQL query regions to reference item session state. If one or more employees are in the department identified by the value of <code>P101_DEPTNO</code>, then the condition evaluates as true.</p> <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="concept_bind_var.htm#BEIEGCCC">"About Bind Variable Syntax"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref153" name="sthref153"></a> <h2><a name="HTMDB25021" id="HTMDB25021"></a>PL/SQL Expression</h2> <p>Use <span class="bold">PL/SQL Expression</span> to specify an expression in valid PL/SQL syntax that evaluates to true or false. For example:</p> <pre xml:space="preserve" class="oac_no_warn"> NVL(:MY_ITEM,'NO') = 'YES' </pre> <p>If the value of <code>:MY_ITEM</code> is Yes, as in the previous example, then the condition evaluates as true. If the value of :MY_ITEM is No, then the condition evaluates as false.</p> </div> <!-- class="sect3" --></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="concept_rendering.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="concept_user_id.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