Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\bldapp_lov_app.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>Creating a Named LOV at the Application Level</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T16:11:29Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Creating a Named LOV at the Application Level" /> <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="app_comp.htm" title="Adding Application Components" type="text/html" /> <link rel="up" href="bldapp_lov.htm" title="Creating Lists of Values" type="text/html" /> <link rel="up" href="bldapp_lov_app.htm" title="Creating a Named LOV at the..." type="text/html" /> <link rel="prev" href="bldapp_lov.htm" title="Previous" type="text/html" /> <link rel="next" href="bldapp_lov_static.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="Home">Home</a> > <a href="app_comp.htm" title="Adding Application Components">Adding Application Components</a> > <a href="bldapp_lov.htm" title="Creating Lists of Values">Creating Lists of Values</a> > Creating a Named LOV at the...</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="bldapp_lov.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_lov_static.htm"><img src="dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDCBEIG" name="CHDCBEIG"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB25450" id="HTMDB25450"></a>Creating a Named <a id="sthref1207" name="sthref1207"></a><a id="sthref1208" name="sthref1208"></a><a id="sthref1209" name="sthref1209"></a>LOV at the Application Level</h1> <p>You define named (or shared) LOVs at the application level by running the <a id="sthref1210" name="sthref1210"></a>Create LOV Wizard and adding them to the List of Values repository. All LOVs can be defined as static or dynamic. Static lists are based on predefined pairs of display values and return values. Dynamic lists are based on a SQL query you write that selects values from a table.</p> <p>To create a named LOV:</p> <ol> <li> <p>On the Workspace home page, click the <span class="bold">Application Builder</span> icon.</p> </li> <li> <p>Select an application.</p> <p>The Application home page appears.</p> </li> <li> <p>Click the <span class="bold">Shared Components</span> icon.</p> </li> <li> <p>Under User Interface, select <span class="bold">Lists of Values</span>.</p> <p>The Lists of Values page appears.</p> </li> <li> <p>To create a LOV, click <span class="bold">Create</span>.</p> </li> <li> <p>Follow the on-screen instructions.</p> <p>New named LOVs are added to the List of Values repository. Note to add the LOV to a page you must edit the appropriate item or column and select the named LOV.</p> </li> </ol> <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="bldapp_rpt_att.htm#BCECDBCB">"Defining a Column as a List of Values in a Classic Report"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref1211" name="sthref1211"></a> <h2><a name="HTMDB25451" id="HTMDB25451"></a>About the List of Values <a id="sthref1212" name="sthref1212"></a><a id="sthref1213" name="sthref1213"></a>Page</h2> <p>Once you create an LOV, it appears on the List of Values page.</p> <img src="img/lov_page.gif" alt="Description of lov_page.gif follows" title="Description of lov_page.gif follows" longdesc="img_text/lov_page.htm" /><br /> <a id="sthref1214" name="sthref1214" href="img_text/lov_page.htm">Description of the illustration lov_page.gif</a><br /> <br /> <p>Use the Navigation bar at the top of the page to search for a LOV by name or change the page display. For example, you can change the default display by making a selection from View list. Available options include:</p> <ul> <li> <p><span class="bold">Icons</span> (the default) displays each LOV as a large icon. To edit an LOV, click the appropriate icon.</p> </li> <li> <p><span class="bold">Details</span> displays each LOV as a line in a report. To edit an LOV, click the name.</p> </li> </ul> </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="bldapp_lov.htm"><img src="dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="bldapp_lov_static.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