Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\ja\TDPAX\td_bldsellst.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="ja" lang="ja"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>???????????????????????</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T18:17:40Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Displaying Items as Select Lists" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E11946-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="build_app.htm" title="Building Your Application" type="text/html" /> <link rel="up" href="td_bldsellst.htm" title="Displaying Items as Select ..." type="text/html" /> <link rel="prev" href="td_bldedit.htm" title="Previous" type="text/html" /> <link rel="next" href="td_bldlink.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="?????">?????</a> > <a href="build_app.htm" title="?????????????????"> ?????????????????</a> > ??????????????????????? </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="td_bldedit.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="td_bldlink.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td> </tr> </table> <p><a id="BCEIBDHI" name="BCEIBDHI"></a></p> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h1><a name="TDPAX04007|how to display select lists"></a><a id="sthref220" name="sthref220"></a><a id="sthref221" name="sthref221"></a><a id="sthref222" name="sthref222"></a><a id="sthref223" name="sthref223"></a>???????????????????????</h1> <p>????????????????????/??????????????????????????????????????????????????????????????????????????????????????????????????????LOV????????????????????????????????????2?????????????????????????????????????</p> <ol> <li> <p>??????????????????????????</p> </li> <li> <p>??????????????????????????????????????????????????OV???????????</p> </li> </ol> <a id="sthref224" name="sthref224"></a> <p class="subhead2">??????:</p> <ul> <li> <p><a href="#BCEDCHFF">???????????</a></p> </li> <li> <p><a href="#BCEBFFAI">???????????????????????????</a></p> </li> </ul> <a id="BCEDCHFF" name="BCEDCHFF"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2><a id="sthref225" name="sthref225"></a><a id="sthref226" name="sthref226"></a>LOV?????</h2> <p>?°????????????????????OV???????????</p> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref227" name="sthref227"></a> <h3>??????LOV?????</h3> <p>?°??????????????OV???????????</p> <ol> <li> <p>??????????????????????????????<span class="bold">????????????????</span>??????????????</p> </li> <li> <p><span class="bold">??4 - ????°????/?????</span>??????????????</p> </li> <li> <p>?????????????????????OV?????<span class="bold">???????</span>????????????????????<span class="bold">???????</span>??????????????????????????????+??????????????????????</p> <img src="img/bldapp_criconlov.gif" alt="??ldapp_criconlov.gif????????????" title="??ldapp_criconlov.gif????????????" longdesc="img_text/bldapp_criconlov.htm" /><br /><a id="sthref228" name="sthref228" href="img_text/bldapp_criconlov.htm">??ldapp_criconlov.gif?????</a><br /><br /> <p>LOV?????????????????????????</p> </li> <li> <p>??????????????????????????<span class="bold">??????????</span>??<span class="bold">???????</span>??????????????</p> </li> <li> <p>????????????????????????????</p> <ol> <li> <p>???: <code>JOBS</code>???????????</p> </li> <li> <p>?????: <span class="bold">Dynamic</span>???????????</p> </li> <li> <p><span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p>??????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT job_title d, job_id v FROM oehr_jobs ORDER BY d </pre> <p>???????????????d??????????????????????????2????????????????????????????????????????????????????????????????????????????????</p> </li> <li> <p><span class="bold">??OV???????</span>??????????????</p> <p>?????????????????????????????????????????????????????????????????????????????????????????????????</p> </li> </ol> </div> <!-- class="sect3" --> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref229" name="sthref229"></a> <h3>????°?LOV?????</h3> <p>?°??????????????OV???????????</p> <ol> <li> <p>??OV???<span class="bold">???????</span>????????????????????</p> </li> <li> <p>??????????????????????????<span class="bold">??????????</span>??<span class="bold">???????</span>??????????????</p> </li> <li> <p>????????????????????????????</p> <ol> <li> <p>???: <code>EMPLOYEES</code>???????????</p> </li> <li> <p>?????: <span class="bold">Dynamic</span>???????????</p> </li> <li> <p><span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p>??????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT first_name ||' '|| last_name d, employee_id v FROM oehr_employees ORDER BY last_name </pre></li> <li> <p><span class="bold">??OV???????</span>??????????????</p> </li> </ol> </div> <!-- class="sect3" --> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref230" name="sthref230"></a> <h3>?????OV?????</h3> <p>?°?????????????OV???????????</p> <ol> <li> <p>??OV???<span class="bold">???????</span>????????????????????</p> </li> <li> <p>??????????????????????????<span class="bold">??????????</span>??<span class="bold">???????</span>??????????????</p> </li> <li> <p>????????????????????????????</p> <ol> <li> <p>???: <code>DEPARTMENTS</code>???????????</p> </li> <li> <p>?????: <span class="bold">Dynamic</span>???????????</p> </li> <li> <p><span class="bold">???????</span>??????????????</p> </li> </ol> </li> <li> <p>??????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT department_name d, department_id v FROM oehr_departments ORDER BY d </pre></li> <li> <p><span class="bold">??OV???????</span>??????????????</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BCEBFFAI" name="BCEBFFAI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h2><a id="sthref231" name="sthref231"></a><a id="sthref232" name="sthref232"></a>?????????????????????????????????</h2> <p>LOV???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????</p> <p>?????4_JOB_ID??4_MANAGER_ID?????4_DEPARTMENT_ID????????????????????</p> <p>?°???????????????????????????????</p> <ol> <li> <p>????????????????????????????????????????????????????????</p> <img src="img/item_sect.gif" alt="??tem_sect.gif????????????" title="??tem_sect.gif????????????" longdesc="img_text/item_sect.htm" /><br /> <a id="sthref233" name="sthref233" href="img_text/item_sect.htm">??tem_sect.gif?????</a><br /> <br /> <p>???????????????????????????????????????????????????????????2????????????????????????????????????????????????????????????????????????</p> </li> <li> <p><span class="bold">??4_JOB_ID??</span>??????????????</p> <p>??????????????????????????????????</p> </li> <li> <p>???????????????????<span class="bold">???????????</span>???????????</p> </li> <li> <p>????????????????????<code>????????</code>???????????</p> </li> <li> <p>??OV???????????????????</p> </li> <li> <p>????????OV???<span class="bold">????????</span>???????????</p> </li> <li> <p><span class="bold">???????????</span>??????????????</p> </li> </ol> <p>?°??????????????????????????????????</p> <ol> <li> <p>?????????????<span class="bold">??4_MANAGER_ID??</span>??????????????</p> </li> <li> <p>???????????????????<span class="bold">???????????</span>???????????</p> </li> <li> <p>????????????????????<code>???????????</code>???????????</p> </li> <li> <p>??OV????°???????????</p> <ol> <li> <p>??????LOV: <span class="bold">EMPLOYEES</span>???????????</p> </li> <li> <p>NULL?????: <span class="bold">???????</span>???????????</p> </li> <li> <p>NULL?????: ?°???????????</p> <pre xml:space="preserve" class="oac_no_warn"> - No Manager Assigned - </pre></li> </ol> <p>????????????????????????????????????????????????????????????????????????????????????????????????????????????ULL????????????????????????????????????????????????????????????????????????????????????</p> </li> <li> <p><span class="bold">???????????</span>??????????????</p> </li> </ol> <p>?°????????????????????????????</p> <ol> <li> <p>?????????????<span class="bold">??4_DEPARTMENT_ID??</span>???????????</p> </li> <li> <p>???????????????????<span class="bold">???????????</span>???????????</p> </li> <li> <p>????????????????????<code>Department</code>???????????</p> </li> <li> <p>??OV????°???????????</p> <ol> <li> <p>??????LOV: <span class="bold">DEPARTMENTS</span>???????????</p> </li> <li> <p>NULL?????: <span class="bold">???????</span>???????????</p> </li> <li> <p>NULL?????: ?°???????????</p> <pre xml:space="preserve" class="oac_no_warn"> - No Department Assigned - </pre></li> </ol> </li> <li> <p><span class="bold">???????????</span>??????????????</p> </li> <li> <p>????????????????</p> <img src="img/bldap_empeditfrm_lst.gif" alt="??ldap_empeditfrm_lst.gif????????????" title="??ldap_empeditfrm_lst.gif????????????" longdesc="img_text/bldap_empeditfrm_lst.htm" /><br /><a id="sthref234" name="sthref234" href="img_text/bldap_empeditfrm_lst.htm">??ldap_empeditfrm_lst.gif?????</a><br /><br /> <p>????????????????????????????????????????????????????????????????????????????????????????????????????????</p> </li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <!-- 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 (C) 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"> <span class="copyrightlogo">???????????</span></a></td> <td align="center"><a href="td_bldedit.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="td_bldlink.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</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