Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\ja\concept_sub_strings.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-14T16:11:25Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="About Built-in Substitution Strings" /> <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_sub.htm" title="Understanding Substitution ..." type="text/html" /> <link rel="up" href="concept_sub_strings.htm" title="About Built-in Substitution..." type="text/html" /> <link rel="prev" href="concept_sub_using.htm" title="Previous" type="text/html" /> <link rel="next" href="bldr.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface.htm" title="?????">?????</a> > <a href="concept.htm" title="????????????????????????">????????????????????????</a> > <a href="concept_sub.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="concept_sub_using.htm"><img src="dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="bldr.htm"><img src="dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td> </tr> </table> <p><a id="BEIIBAJD" name="BEIIBAJD"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1><a name="HTMDB03024|About Built-in Substitution Strings"></a>??????????????????<a id="sthref206" name="sthref206"></a><a id="sthref207" name="sthref207"></a></h1> <p>?????????????????????????????????????????????????????????????????????????????????????????????????????</p> <p>?°??????????????????????????????????????????????????????????????????????????????????<code>:USER</code>?????????????????????????????????????????????????<span class="bold">???PL/SQL</span>???????????????????????????????????????????????????????????????????????????PL/SQL??????????</p> <a id="sthref208" name="sthref208"></a> <p class="subhead2">??????:</p> <ul> <li> <p><a href="#BEIGGDII">APP_ALIAS</a></p> </li> <li> <p><a href="#BEIBCBBE">APP_ID</a></p> </li> <li> <p><a href="#BEIDCGAJ">APP_IMAGES</a></p> </li> <li> <p><a href="#BEIEIDAB">APP_PAGE_ID</a></p> </li> <li> <p><a href="#BEIEHEJI">APP_SESSION</a></p> </li> <li> <p><a href="#BEICBHCG">APP_UNIQUE_PAGE_ID</a></p> </li> <li> <p><a href="#BEIHCJBG">APP_USER</a></p> </li> <li> <p><a href="#BEIJEDHH">AUTHENTICATED_URL_PREFIX</a></p> </li> <li> <p><a href="#BEIDEHFE">BROWSER_LANGUAGE</a></p> </li> <li> <p><a href="#BEIDBCBG">CURRENT_PARENT_TAB_TEXT</a></p> </li> <li> <p><a href="#BEIFAGIE">DEBUG</a></p> </li> <li> <p><a href="#CIHHHHDD">HOME_LINK</a></p> </li> <li> <p><a href="#BCEHHHGD">LOGIN_URL</a></p> </li> <li> <p><a href="#BEIGJJBG">IMAGE_PREFIX</a></p> </li> <li> <p><a href="#BEIJFFEE">Application Express SCHEMA OWNER</a></p> </li> <li> <p><a href="#BEIFGGJB">PRINTER_FRIENDLY</a></p> </li> <li> <p><a href="#BEICHGAC">LOGOUT_URL</a></p> </li> <li> <p><a href="#BEIJDAHC">PROXY_SERVER</a></p> </li> <li> <p><a href="#BEIIGFGF">PUBLIC_URL_PREFIX</a></p> </li> <li> <p><a href="#BEIFJJBC">REQUEST</a></p> </li> <li> <p><a href="#BEIECHFH">SQLERRM</a></p> </li> <li> <p><a href="#BEIGGIFI">SYSDATE_YYYYMMDD</a></p> </li> <li> <p><a href="#BEICEJEA">WORKSPACE_IMAGES</a></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">???:</p> <ul> <li> <p>???????????????????????????????????????????????????<a href="bldr_attr_standard.htm#CHDBEHDJ">???????</a>????????????????</p> </li> <li> <p>?????????????<a href="sec_authentication.htm#BABHIEIA">???????????????????????????????????</a>????????????????</p> </li> </ul> </td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="BEIGGDII" name="BEIGGDII"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25033" id="HTMDB25033"></a>APP_ALIAS<a id="sthref209" name="sthref209"></a></h2> <p><code>APP_ALIAS</code>???????????????????????????????????????<code>APP_ALIAS</code>????<code>APP_ID</code>??1???????????????????????????????????????????????????????????????????????????????????????????<code>APP_ID</code>???????????<code>APP_ALIAS</code>?????????????????????????????????????????1???<code>APP_ALIAS</code>????????2???????????????ABC?????????????????????????????????????<code>APP_ALIAS</code>????<code>APP_ID</code>??????????????????????????????????????????????????????????????????<code>f?p</code>?????<code>APP_ALIAS</code>?????????????????D?????????????</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=ABC:1:&APP_SESSION. </pre> <p>??????????????????????BC??????1?????????????????????????????????????</p> <p><a href="#BEIIDDEJ">????PP_ALIAS?????</a>????<code>APP_ALIAS</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref210" name="sthref210"></a><a id="BEIIDDEJ" name="BEIIDDEJ"></a> <p class="titleintable">APP_ALIAS???</p> <table class="Formal" title="APP_ALIAS???" summary="??????????PP_ALIAS??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="41%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t21">????????</th> <th align="left" valign="bottom" id="r1c2-t21">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t21" headers="r1c1-t21"> <p>?????????</p> </td> <td align="left" headers="r2c1-t21 r1c2-t21"> <p><code>:APP_ALIAS</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t21" headers="r1c1-t21"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t21 r1c2-t21"> <p><code>V('APP_ALIAS')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t21" headers="r1c1-t21"> <p>????????</p> </td> <td align="left" headers="r4c1-t21 r1c2-t21"> <p><code>&APP_ALIAS.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°???TML?????????????</p> <pre xml:space="preserve" class="oac_no_warn"> Click me to go to page 1 <a href="f?p=&APP_ALIAS.:1:&APP_SESSION."> of the current application</a> </pre></div> <!-- class="sect3" --> <a id="BEIBCBBE" name="BEIBCBBE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25034" id="HTMDB25034"></a>APP_ID<a id="sthref211" name="sthref211"></a></h2> <p><code>APP_ID</code>???????????????????????????????????????????D??????????<a href="#BEIIGDCA">????PP_ID?????</a>????<code>APP_ID</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref212" name="sthref212"></a><a id="BEIIGDCA" name="BEIIGDCA"></a> <p class="titleintable">APP_ID???</p> <table class="Formal" title="APP_ID???" summary="??????????PP_ID??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="28%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t22">????????</th> <th align="left" valign="bottom" id="r1c2-t22">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t22" headers="r1c1-t22"> <p>?????????</p> </td> <td align="left" headers="r2c1-t22 r1c2-t22"> <p><code>:APP_ID</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t22" headers="r1c1-t22"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t22 r1c2-t22"> <p><code>APEX_APPLICATION.G_FLOW_ID (A NUMBER)</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t22" headers="r1c1-t22"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t22 r1c2-t22"> <p><code>NV('APP_ID')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t22" headers="r1c1-t22"> <p>????????</p> </td> <td align="left" headers="r5c1-t22 r1c2-t22"> <p><code>&APP_ID.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°???????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=&APP_ID.:40:&APP_SESSION. </pre></div> <!-- class="sect3" --> <a id="BEIDCGAJ" name="BEIDCGAJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25035" id="HTMDB25035"></a>APP_IMAGES<a id="sthref213" name="sthref213"></a></h2> <p>???????????????????????????????????????????????????????????????????????????????????????????°?????avaScript?????????????????????????????????????°???????????????????????°????????????????????????????????????????????????????????????????????????????<a href="#BEIGIHGH">????PP_IMAGES?????</a>????<code>APP_IMAGES</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref214" name="sthref214"></a><a id="BEIGIHGH" name="BEIGIHGH"></a> <p class="titleintable">APP_IMAGES???</p> <table class="Formal" title="APP_IMAGES???" summary="??????????PP_IMAGES??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t23">????????</th> <th align="left" valign="bottom" id="r1c2-t23">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t23" headers="r1c1-t23"> <p>?????????</p> </td> <td align="left" headers="r2c1-t23 r1c2-t23"> <p><code>:APP_IMAGES</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t23" headers="r1c1-t23"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t23 r1c2-t23"> <p>??????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t23" headers="r1c1-t23"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t23 r1c2-t23"> <p><code>V('APP_IMAGES')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t23" headers="r1c1-t23"> <p>????????</p> </td> <td align="left" headers="r5c1-t23 r1c2-t23"> <p><code>&APP_IMAGES.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t23" headers="r1c1-t23"> <p>????????????</p> </td> <td align="left" headers="r6c1-t23 r1c2-t23"> <p><code>#APP_IMAGES#</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <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">???:</p> <a href="#BEIGJJBG">??MAGE_PREFIX??</a>??<a href="#BEICEJEA">??ORKSPACE_IMAGES??</a>?????<a href="ui_upload_img.htm#BABDIEBI">????°?????????</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BEIEIDAB" name="BEIEIDAB"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25036" id="HTMDB25036"></a>APP_PAGE_ID<a id="sthref215" name="sthref215"></a></h2> <p><code>APP_PAGE_ID</code>?????????????????????ID??????????????????????????3???????????????????????3?????????????????????????????????????????????????????????????????????????????????????????????????????????<a href="#BEIDDHCJ">????PP_PAGE_ID?????</a>????<code>APP_PAGE_ID</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref216" name="sthref216"></a><a id="BEIDDHCJ" name="BEIDDHCJ"></a> <p class="titleintable">APP_PAGE_ID???</p> <table class="Formal" title="APP_PAGE_ID???" summary="??????????PP_PAGE_ID??????????????????????????????????????" 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-t25">????????</th> <th align="left" valign="bottom" id="r1c2-t25">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t25" headers="r1c1-t25"> <p>?????????</p> </td> <td align="left" headers="r2c1-t25 r1c2-t25"> <p><code>:APP_PAGE_ID</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t25" headers="r1c1-t25"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t25 r1c2-t25"> <p><code>:APP_PAGE_ID</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t25" headers="r1c1-t25"> <p>PL/SQL????????L</p> </td> <td align="left" headers="r4c1-t25 r1c2-t25"> <p><code>NV('APP_PAGE_ID')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t25" headers="r1c1-t25"> <p>????????</p> </td> <td align="left" headers="r5c1-t25 r1c2-t25"> <p><code>&APP_PAGE_ID</code>.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°???????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION. </pre></div> <!-- class="sect3" --> <a id="BEIEHEJI" name="BEIEHEJI"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25037" id="HTMDB25037"></a>APP_SESSION<a id="sthref217" name="sthref217"></a></h2> <p><code>APP_SESSION</code>???????????????????????????????1???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<code>APP_SESSION</code>???????????????<code>SESSION</code>????????????????????<a href="#BEIDDEFB">????PP_SESSION?????</a>????<code>APP_SESSION</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref218" name="sthref218"></a><a id="BEIDDEFB" name="BEIDDEFB"></a> <p class="titleintable">APP_SESSION???</p> <table class="Formal" title="APP_SESSION???" summary="??????????PP_SESSION??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="40%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t26">????????</th> <th align="left" valign="bottom" id="r1c2-t26">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t26" headers="r1c1-t26"> <p>?????????</p> </td> <td align="left" headers="r2c1-t26 r1c2-t26"> <p><code>:APP_SESSION</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t26" headers="r1c1-t26"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t26 r1c2-t26"> <p><code>V('APP_SESSION')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t26" headers="r1c1-t26"> <p>???PL/SQL</p> </td> <td align="left" headers="r4c1-t26 r1c2-t26"> <p><code>V('SESSION')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t26" headers="r1c1-t26"> <p>????????</p> </td> <td align="left" headers="r5c1-t26 r1c2-t26"> <p><code>&APP_SESSION.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°????????????</p> <ul> <li> <p>HTML?????????????????:</p> <pre xml:space="preserve" class="oac_no_warn"> <a href="f?p=100:5:&APP_SESSION.">click me</a> </pre></li> <li> <p>PL/SQL???????????:</p> <pre xml:space="preserve" class="oac_no_warn"> htf.anchor('f?p=100:5:'||V('APP_SESSION'),'click me'); </pre></li> <li> <p>SQL???????????????:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT htf.anchor('f?p=100:5:'||:APP_SESSION,'clickme') FROM DUAL; </pre></li> </ul> </div> <!-- class="sect3" --> <a id="BEICBHCG" name="BEICBHCG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25038" id="HTMDB25038"></a>APP_UNIQUE_PAGE_ID<a id="sthref219" name="sthref219"></a></h2> <p><code>APP_UNIQUE_PAGE_ID</code>??????????????????????racle??????????????????????????????????????????????????????????????????????????????????????????????????????????????????URL?????????????????????????????????????????????????<code>f</code>?????????????????????????????????????????????????????????????<a href="#BEIGGEHC">????PP_UNIQUE_PAGE_ID?????</a>????<code>APP_UNIQUE_PAGE_ID</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref220" name="sthref220"></a><a id="BEIGGEHC" name="BEIGGEHC"></a> <p class="titleintable">APP_UNIQUE_PAGE_ID???</p> <table class="Formal" title="APP_UNIQUE_PAGE_ID???" summary="??????????PP_UNIQUE_PAGE_ID??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="35%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t27">????????</th> <th align="left" valign="bottom" id="r1c2-t27">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t27" headers="r1c1-t27"> <p>?????????</p> </td> <td align="left" headers="r2c1-t27 r1c2-t27"> <p><code>:APP_UNIQUE_PAGE_ID</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t27" headers="r1c1-t27"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t27 r1c2-t27"> <p><code>V('APP_UNIQUE_PAGE_ID')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t27" headers="r1c1-t27"> <p>????????</p> </td> <td align="left" headers="r4c1-t27 r1c2-t27"> <p><code>&APP_UNIQUE_PAGE_ID</code>.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°???TML?????????????</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT 'f?p=100:1:'||:APP_SESSION||':'||:APP_UNIQUE_PAGE_ID|| ':::P1_EMPNO:'||employee_id, first_name, job_id FROM employees </pre> <p>???????????<code>APP_UNIQUE_PAGE_ID</code>?????????????????????????????????????????????RL??????????????????????????????????????????????????</p> </div> <!-- class="sect3" --> <a id="BEIHCJBG" name="BEIHCJBG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25039" id="HTMDB25039"></a>APP_USER<a id="sthref221" name="sthref221"></a></h2> <p><code>APP_USER</code>?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????USER????????????????????????????????????????????????????????????????????<code>APP_USER</code>???????????????????????????????????????????????????????????????????????<a href="#BEIHFDGB">????PP_USER?????</a>????<code>APP_USER</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref222" name="sthref222"></a><a id="BEIHFDGB" name="BEIHFDGB"></a> <p class="titleintable">APP_USER???</p> <table class="Formal" title="APP_USER???" summary="??????????PP_USER??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="30%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t28">????????</th> <th align="left" valign="bottom" id="r1c2-t28">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t28" headers="r1c1-t28"> <p>?????????</p> </td> <td align="left" headers="r2c1-t28 r1c2-t28"> <p><code>:APP_USER</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t28" headers="r1c1-t28"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t28 r1c2-t28"> <p><code>V('APP_USER')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t28" headers="r1c1-t28"> <p>????????</p> </td> <td align="left" headers="r4c1-t28 r1c2-t28"> <p><code>&APP_USER.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°????????????</p> <ul> <li> <p>HTML?????????????????:</p> <pre xml:space="preserve" class="oac_no_warn"> Hello you are logged in as &APP_USER. </pre></li> <li> <p>PL/SQL???????????:</p> <pre xml:space="preserve" class="oac_no_warn"> htp.p('Hello you are logged in as'||V('APP_USER')); </pre></li> <li> <p>??????????????????:</p> <pre xml:space="preserve" class="oac_no_warn"> SELECT * FROM some_table WHERE user_id = :APP_USER </pre> <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">???:</p> ???????????????????????????<a href="bldr_attr_sec.htm#CHDIFJEI">???????</a>????????????????</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </li> </ul> </div> <!-- class="sect3" --> <a id="BEIJEDHH" name="BEIJEDHH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25040" id="HTMDB25040"></a>AUTHENTICATED_URL_PREFIX<a id="sthref223" name="sthref223"></a></h2> <p>????????????????????????????????????????????????????????RL???????????????????????????<code>http</code>?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<code>AUTHENTICATED_URL_PREFIX</code>?????????????????????????????????????????????????????asic?????????????????????????????????????RL??????????????????????????????????<a href="#BEIHJJHH">????UTHENTICATED_URL_PREFIX?????</a>????<code>AUTHENTICATED_URL_PREFIX</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref224" name="sthref224"></a><a id="BEIHJJHH" name="BEIHJJHH"></a> <p class="titleintable">AUTHENTICATED_URL_PREFIX???</p> <table class="Formal" title="AUTHENTICATED_URL_PREFIX???" summary="??????????UTHENTICATED_URL_PREFIX??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="32%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t30">????????</th> <th align="left" valign="bottom" id="r1c2-t30">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t30" headers="r1c1-t30"> <p>?????????</p> </td> <td align="left" headers="r2c1-t30 r1c2-t30"> <p><code>:AUTHENTICATED_URL_PREFIX</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t30" headers="r1c1-t30"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t30 r1c2-t30"> <p><code>V('AUTHENTICATED_URL_PREFIX')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t30" headers="r1c1-t30"> <p>????????</p> </td> <td align="left" headers="r4c1-t30 r1c2-t30"> <p><code>&AUTHENTICATED_URL_PREFIX.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIDEHFE" name="BEIDEHFE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25041" id="HTMDB25041"></a>BROWSER_LANGUAGE<a id="sthref225" name="sthref225"></a></h2> <p><code>BROWSER_LANGUAGE</code>????eb?????????????????????°???????????????<a href="#BEIDAHGH">????ROWSER_LANGUAGE?????</a>????<code>BROWSER_LANGUAGE</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref226" name="sthref226"></a><a id="BEIDAHGH" name="BEIDAHGH"></a> <p class="titleintable">BROWSER_LANGUAGE???</p> <table class="Formal" title="BROWSER_LANGUAGE???" summary="??????????ROWSER_LANGUAGE??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="38%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t31">????????</th> <th align="left" valign="bottom" id="r1c2-t31">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t31" headers="r1c1-t31"> <p>?????????</p> </td> <td align="left" headers="r2c1-t31 r1c2-t31"> <p><code>:BROWSER_LANGUAGE</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t31" headers="r1c1-t31"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t31 r1c2-t31"> <p><code>APEX_APPLICATION.G_BROWSER_LANGUAGE</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t31" headers="r1c1-t31"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t31 r1c2-t31"> <p><code>V('BROWSER_LANGUAGE')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t31" headers="r1c1-t31"> <p>????????</p> </td> <td align="left" headers="r5c1-t31 r1c2-t31"> <p><code>:BROWSER_LANGUAGE.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t31" headers="r1c1-t31"> <p>????????</p> </td> <td align="left" headers="r6c1-t31 r1c2-t31"> <p><code>&BROWSER_LANGUAGE.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIDBCBG" name="BEIDBCBG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25042" id="HTMDB25042"></a>CURRENT_PARENT_TAB_TEXT<a id="sthref227" name="sthref227"></a></h2> <p><code>CURRENT_PARENT_TAB_TEXT</code>?????????????????????????????????????????????????2???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<a href="#BEIBJDEJ">????URRENT_PARENT_TAB_TEXT?????</a>????<code>CURRENT_PARENT_TAB_TEXT</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref228" name="sthref228"></a><a id="BEIBJDEJ" name="BEIBJDEJ"></a> <p class="titleintable">CURRENT_PARENT_TAB_TEXT???</p> <table class="Formal" title="CURRENT_PARENT_TAB_TEXT???" summary="??????????URRENT_PARENT_TAB_TEXT??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="39%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t32">????????</th> <th align="left" valign="bottom" id="r1c2-t32">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t32" headers="r1c1-t32"> <p>?????????</p> </td> <td align="left" headers="r2c1-t32 r1c2-t32"> <p>??????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t32" headers="r1c1-t32"> <p>????????</p> </td> <td align="left" headers="r3c1-t32 r1c2-t32"> <p><code>&CURRENT_PARENT_TAB_TEXT.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIFAGIE" name="BEIFAGIE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25043" id="HTMDB25043"></a>DEBUG<a id="sthref229" name="sthref229"></a></h2> <p><code>DEBUG</code>????????????Yes?????o????????????????????????????????????????????????????????????????????????????????????????????????Yes?????????????????????????????????????????<a href="#BEIBAFJD">????EBUG?????</a>????<code>DEBUG</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref230" name="sthref230"></a><a id="BEIBAFJD" name="BEIBAFJD"></a> <p class="titleintable">DEBUG???</p> <table class="Formal" title="DEBUG???" summary="??????????EBUG??????????????????????????????????????" 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-t33">????????</th> <th align="left" valign="bottom" id="r1c2-t33">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t33" headers="r1c1-t33"> <p>?????????</p> </td> <td align="left" headers="r2c1-t33 r1c2-t33"> <p>:<code>DEBUG</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t33" headers="r1c1-t33"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t33 r1c2-t33"> <p><code>APEX_APPLICATION.G_DEBUG</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t33" headers="r1c1-t33"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t33 r1c2-t33"> <p><code>V('DEBUG')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t33" headers="r1c1-t33"> <p>????????</p> </td> <td align="left" headers="r5c1-t33 r1c2-t33"> <p><code>&DEBUG</code>.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>?°???<code>DEBUG</code>????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=100:1:&APP_SESSION.::&DEBUG </pre></div> <!-- class="sect3" --> <a id="CIHHHHDD" name="CIHHHHDD"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25044" id="HTMDB25044">HOME_LINK</a></h2> <p><code>HOME_LINK</code>??????????????????????????????????????????????????????????????????????????????????????????????????????pplication Express???????????????????????????????????????OME_LINK????????????????????????????????</p> <p><a href="#CIHIHJBA">????OME_LINK?????</a>????OME_LINK??????????????????????????????????????</p> <div class="tblformal"><a id="sthref231" name="sthref231"></a><a id="CIHIHJBA" name="CIHIHJBA"></a> <p class="titleintable">HOME_LINK???</p> <table class="Formal" title="HOME_LINK???" summary="??????????OME LINK??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="27%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t34">????????</th> <th align="left" valign="bottom" id="r1c2-t34">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t34" headers="r1c1-t34"> <p>???PL/SQL</p> </td> <td align="left" headers="r2c1-t34 r1c2-t34"> <p><code>APEX_APPLICATION.G_HOME_LINK</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t34" headers="r1c1-t34"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t34 r1c2-t34"> <p><code>V('HOME_LINK')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t34" headers="r1c1-t34"> <p>????????????</p> </td> <td align="left" headers="r4c1-t34 r1c2-t34"> <p><code>#HOME_LINK#</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t34" headers="r1c1-t34"> <p>????????</p> </td> <td align="left" headers="r5c1-t34 r1c2-t34"> <p><code>&HOME_LINK.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <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">???:</p> ???????????????????????<a href="bldr_attr_sec.htm#CHDIFJEI">???????</a>????????????????</td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --> <a id="BCEHHHGD" name="BCEHHHGD"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25045" id="HTMDB25045">LOGIN_URL</a></h2> <p>??????????????????????????????????????????????????????????<code>LOGIN_URL</code>???????????<a href="#BCEICJGB">????OGIN_URL?????</a>????<code>LOGIN_URL</code>??????????????????????????????????????</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">???:</p> <a href="bldr_attr_sec.htm#CHDIFJEI">???????</a>?????<a href="bldr_attr_sec.htm#CHDHIBHE">??????????????????????????</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div class="tblformal"><a id="sthref232" name="sthref232"></a><a id="BCEICJGB" name="BCEICJGB"></a> <p class="titleintable">LOGIN_URL???</p> <table class="Formal" title="LOGIN_URL???" summary="??????????OGIN_URL??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t37">????????</th> <th align="left" valign="bottom" id="r1c2-t37">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t37" headers="r1c1-t37"> <p>?????????</p> </td> <td align="left" headers="r2c1-t37 r1c2-t37"> <p><code>:LOGIN_URL</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t37" headers="r1c1-t37"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t37 r1c2-t37"> <p><code>APEX_APPLICATION.G_LOGIN_URL</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t37" headers="r1c1-t37"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t37 r1c2-t37"> <p><code>V('LOGIN_URL')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t37" headers="r1c1-t37"> <p>????????</p> </td> <td align="left" headers="r5c1-t37 r1c2-t37"> <p><code>&LOGIN_URL.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t37" headers="r1c1-t37"> <p>????????????</p> </td> <td align="left" headers="r6c1-t37 r1c2-t37"> <p><code>#LOGIN_URL#</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIGJJBG" name="BEIGJJBG"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25046" id="HTMDB25046"></a>IMAGE_PREFIX<a id="sthref233" name="sthref233"></a></h2> <p><code>IMAGE_PREFIX</code>????????????racle Application Express????????????????°??????????????????????Web???????????????????????????????????????????????????????????????<code>WORKSPACE_IMAGES</code>?????<code>APP_IMAGES</code>???????????<a href="#BEIJJICI">????MAGE_PREFIX?????</a>????<code>IMAGE_PREFIX</code>??????????????????????????????????????</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">???:</p> <a href="#BEIDCGAJ">??PP_IMAGES??</a>??<a href="#BEICEJEA">??ORKSPACE_IMAGES??</a>?????<a href="bldr_attr_standard.htm#CHDGJHDC">???????????????????????</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <div class="tblformal"><a id="sthref234" name="sthref234"></a><a id="BEIJJICI" name="BEIJJICI"></a> <p class="titleintable">IMAGE_PREFIX???</p> <table class="Formal" title="IMAGE_PREFIX???" summary="??????????MAGE_PREFIX??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t39">????????</th> <th align="left" valign="bottom" id="r1c2-t39">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t39" headers="r1c1-t39"> <p>?????????</p> </td> <td align="left" headers="r2c1-t39 r1c2-t39"> <p><code>:IMAGE_PREFIX</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t39" headers="r1c1-t39"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t39 r1c2-t39"> <p><code>APEX_APPLICATION.G_IMAGE_PREFIX</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t39" headers="r1c1-t39"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t39 r1c2-t39"> <p><code>V('IMAGE_PREFIX')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t39" headers="r1c1-t39"> <p>????????</p> </td> <td align="left" headers="r5c1-t39 r1c2-t39"> <p><code>&IMAGE_PREFIX.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t39" headers="r1c1-t39"> <p>????????????</p> </td> <td align="left" headers="r6c1-t39 r1c2-t39"> <p><code>#IMAGE_PREFIX#</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIJFFEE" name="BEIJFFEE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25047" id="HTMDB25047"></a>Application Express SCHEMA OWNER<a id="sthref235" name="sthref235"></a></h2> <p>PL/SQL????????????????????????????????????????racle Application Express????????????????????????????????????????????????L/SQL????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_APPLICATION.G_FLOW_SCHEMA_OWNER </pre> <p>?????<code>#FLOW_OWNER#</code>????????QL?????????PL/SQL????????????????????????????????????????????????</p> </div> <!-- class="sect3" --> <a id="BEIFGGJB" name="BEIFGGJB"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25048" id="HTMDB25048"></a>PRINTER_FRIENDLY<a id="sthref236" name="sthref236"></a></h2> <p><code>PRINTER_FRIENDLY</code>????????????pplication Express????????????????????????????????????????????????????????????????????????????????????????????????????????????????<a href="#BEIGFGGE">????RINTER_FRIENDLY?????</a>????<code>PRINTER_FRIENDLY</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref237" name="sthref237"></a><a id="BEIGFGGE" name="BEIGFGGE"></a> <p class="titleintable">PRINTER_FRIENDLY???</p> <table class="Formal" title="PRINTER_FRIENDLY???" summary="??????????RINTER_FRIENDLY??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="25%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t40">????????</th> <th align="left" valign="bottom" id="r1c2-t40">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t40" headers="r1c1-t40"> <p>???PL/SQL</p> </td> <td align="left" headers="r2c1-t40 r1c2-t40"> <p><code>APEX_APPLICATION.G_PRINTER_FRIENDLY (VARCHAR2 DATATYPE)</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t40" headers="r1c1-t40"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t40 r1c2-t40"> <p><code>V('PRINTER_FRIENDLY')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t40" headers="r1c1-t40"> <p>????????</p> </td> <td align="left" headers="r4c1-t40 r1c2-t40"> <p><code>&PRINTER_FRIENDLY.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEICHGAC" name="BEICHGAC"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25049" id="HTMDB25049"></a>LOGOUT_URL<a id="sthref238" name="sthref238"></a></h2> <p><code>LOGOUT_URL</code>??????????????????????????????????????URL???????????????????????????????????????????????????????????????????????????????????????????RL?????????????????????????????????????????????????<code>&LOGOUT_URL</code>???????????????????????<code>&LOGOUT_URL.</code>??????????????????????????????????????????<code>#LOGOUT_URL#</code>???????????<a href="#BEIIAGGB">????OGOUT_URL?????</a>????<code>LOGOUT_URL</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref239" name="sthref239"></a><a id="BEIIAGGB" name="BEIIAGGB"></a> <p class="titleintable">LOGOUT_URL???</p> <table class="Formal" title="LOGOUT_URL???" summary="??????????OGOUT_URL??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="32%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t41">????????</th> <th align="left" valign="bottom" id="r1c2-t41">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t41" headers="r1c1-t41"> <p>?????????</p> </td> <td align="left" headers="r2c1-t41 r1c2-t41"> <p><code>:LOGOUT_URL</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t41" headers="r1c1-t41"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t41 r1c2-t41"> <p><code>V('LOGOUT_URL')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t41" headers="r1c1-t41"> <p>????????</p> </td> <td align="left" headers="r4c1-t41 r1c2-t41"> <p><code>&LOGOUT_URL.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t41" headers="r1c1-t41"> <p>????????????</p> </td> <td align="left" headers="r5c1-t41 r1c2-t41"> <p><code>#LOGOUT_URL#</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIJDAHC" name="BEIJDAHC"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25050" id="HTMDB25050"></a>PROXY_SERVER<a id="sthref240" name="sthref240"></a></h2> <p><code>PROXY SERVER</code>???????????????????????????????????????RL??????????????????????????????????????????????L/SQL???????????????????????????????????????????????????????eb?????????????????????PL/SQL?????????????????????????????????????????????<code>utl_http</code>??????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_APPLICATION.G_PROXY_SERVER </pre></div> <!-- class="sect3" --> <a id="BEIIGFGF" name="BEIIGFGF"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25051" id="HTMDB25051"></a>PUBLIC_URL_PREFIX<a id="sthref241" name="sthref241"></a></h2> <p><code>PUBLIC_URL_PREFIX</code>??????????????????????????????????????????????????????????????????RL???????????<a href="#BEIEBGBE">????UBLIC_URL_PREFIX?????</a>????<code>PUBLIC_URL_PREFIX</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref242" name="sthref242"></a><a id="BEIEBGBE" name="BEIEBGBE"></a> <p class="titleintable">PUBLIC_URL_PREFIX???</p> <table class="Formal" title="PUBLIC_URL_PREFIX???" summary="??????????UBLIC_URL_PREFIX??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="32%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t42">????????</th> <th align="left" valign="bottom" id="r1c2-t42">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t42" headers="r1c1-t42"> <p>?????????</p> </td> <td align="left" headers="r2c1-t42 r1c2-t42"> <p><code>:PUBLIC_URL_PREFIX</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t42" headers="r1c1-t42"> <p>PL/SQL</p> </td> <td align="left" headers="r3c1-t42 r1c2-t42"> <p><code>V('PUBLIC_URL_PREFIX')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t42" headers="r1c1-t42"> <p>????????</p> </td> <td align="left" headers="r4c1-t42 r1c2-t42"> <p><code>&PUBLIC_URL_PREFIX.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t42" headers="r1c1-t42"> <p>????????????</p> </td> <td align="left" headers="r5c1-t42 r1c2-t42"> <p><code>#PUBLIC_URL_PREFIX#</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEIFJJBC" name="BEIFJJBC"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25052" id="HTMDB25052"></a>REQUEST<a id="sthref243" name="sthref243"></a><a id="sthref244" name="sthref244"></a><a id="sthref245" name="sthref245"></a></h2> <p><code>REQUEST</code>???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????<code>f?p</code>????????<code>REQUEST</code>??4??????????????????????????</p> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref246" name="sthref246"></a> <h3><a name="HTMDB25053" id="HTMDB25053"></a>REQUEST????????</h3> <p><code>REQUEST</code>??????????????????????????????????????????????????????????????<a href="#BEIDAIED">????EQUEST?????</a>????<code>REQUEST</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref247" name="sthref247"></a><a id="BEIDAIED" name="BEIDAIED"></a> <p class="titleintable">REQUEST???</p> <table class="Formal" title="REQUEST???" summary="??????????EQUEST??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="29%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t43">????????</th> <th align="left" valign="bottom" id="r1c2-t43">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t43" headers="r1c1-t43"> <p>?????????</p> </td> <td align="left" headers="r2c1-t43 r1c2-t43"> <p><code>:REQUEST</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t43" headers="r1c1-t43"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t43 r1c2-t43"> <p><code>APEX_APPLICATION.G_REQUEST</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t43" headers="r1c1-t43"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t43 r1c2-t43"> <p><code>V('REQUEST')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t43" headers="r1c1-t43"> <p>????????</p> </td> <td align="left" headers="r5c1-t43 r1c2-t43"> <p><code>&REQUEST</code></p> <p><code>&REQUEST.</code> ??????????????</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref248" name="sthref248"></a> <h3><a name="HTMDB25054" id="HTMDB25054"></a>???????????????REQUEST??????????????</h3> <p>????????????????????????????????????????????????????????????????????????????????????????????????<code>REQUEST</code>???????????????????????????????????????????????????????????????????????????<code>REQUEST</code>??ULL?????????????</p> <p><code>REQUEST</code>??????????????????????????????????????????????????????????????????????????????<code>CHANGE</code>?????????????????????????????????????????????????????????????????????<code>REQUEST</code>?????<code>CHANGE</code>??????????<code></code></p> </div> <!-- class="sect4" --> <a id="CHDDCFIJ" name="CHDDCFIJ"></a> <div class="sect4"><!-- infolevel="all" infotype="General" --> <h3><a name="HTMDB25055" id="HTMDB25055"></a><a id="sthref249" name="sthref249"></a><a id="sthref250" name="sthref250"></a><a id="sthref251" name="sthref251"></a>????°???????????????</h3> <p>????????????????????????????°???????????????????????????????????????????????????????????????????????????????????°??????????????????????????<code>REQUEST</code>?????????????????????????????????????</p> <p>????????????????????????????<code>REQUEST</code>??????????°????????????????????????????????????°???????????????????????????????????????????°???????????????????????????????????????????????????????????1?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????avaScript??????????????????????????°??????</p> </div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref252" name="sthref252"></a> <h3><a name="HTMDB25056" id="HTMDB25056"></a>??????????????EQUEST?????</h3> <p><code>REQUEST</code>????????????????????????????????????????????????????????????<span class="bold">???????</span>??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????=??1???????????????????????????????<code></code></p> <p>??????????????????????????????????????????????????????</p> <ol> <li> <p>?????????????????<span class="bold">?????????=??1??</span>???????????</p> </li> <li> <p>??1??<span class="bold">???????</span>???????????</p> </li> </ol> </div> <!-- class="sect4" --> <div class="sect4"><!-- infolevel="all" infotype="General" --><a id="sthref253" name="sthref253"></a> <h3><a name="HTMDB25057" id="HTMDB25057"></a>????????????REQUEST?????</h3> <p><code>REQUEST</code>????<code>f?p</code>????????????????????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> f?p=100:1:&APP_SESSION.:GO </pre> <p><code>f?p</code>?????4?????????<code>REQUEST</code>??????????????????????????????????????????100??????1????????<code>REQUEST</code>?????<code>GO</code>??????????????????????????????????????????????????????????<code>REQUEST</code>????????????????</p> <p>?°???L/SQL???????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> IF V ('REQUEST') = 'GO' THEN htp.p('hello'); END IF; </pre> <p><code>htp.p('hello')</code>???????????????????????????????L/SQL Web?????????????????????????????????????????????????</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">???:</p> <ul> <li> <p>PL/SQL????????eb?????????????????????????<a href="http://www.oracle.com/pls/db112/lookup?id=ADFNS"><span class="italic">Oracle Database????????????????????????????????</span></a>????????????????</p> </li> <li> <p>htp????????????????<a href="http://www.oracle.com/pls/db112/lookup?id=ARPLS"><span class="italic">Oracle Database PL/SQL??????????????????????????????????????</span></a>????????????????</p> </li> </ul> </td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect4" --></div> <!-- class="sect3" --> <a id="BEIECHFH" name="BEIECHFH"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25058" id="HTMDB25058"></a>SQLERRM<a id="sthref254" name="sthref254"></a></h2> <p><code>SQLERRM</code>?????????????????????????????????°????????????????????????????????????????????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> #SQLERRM# </pre></div> <!-- class="sect3" --> <a id="BEIGGIFI" name="BEIGGIFI"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25059" id="HTMDB25059"></a>SYSDATE_YYYYMMDD<a id="sthref255" name="sthref255"></a></h2> <p><code>SYSDATE_YYYYMMDD</code>???????????????????????????????<code><span class="codeinlineitalic">YYYYMMDD</span></code>?????????????????????????????????<code>SYSDATE()</code>??????????????????????????????????????????????????????<code>SYSDATE_YYYYMMDD</code>??????????????????????????????????????</p> <ul> <li> <p>?????????</p> <pre xml:space="preserve" class="oac_no_warn"> :SYSDATE_YYYYMMDD </pre></li> <li> <p>PL/SQL</p> <pre xml:space="preserve" class="oac_no_warn"> V('SYSDATE_YYYYMMDD') </pre></li> <li> <p>???PL/SQL</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_APPLICATION.G_SYSDATE (DATE DATATYPE) </pre></li> </ul> <div class="tblformal"><a id="sthref256" name="sthref256"></a><a id="BEIHFJDA" name="BEIHFJDA"></a> <p class="titleintable">SYSDATE_YYYYMMDD???</p> <table class="Formal" title="SYSDATE_YYYYMMDD???" summary="??????????YSDATE_YYYYMMDD??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="24%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t45">????????</th> <th align="left" valign="bottom" id="r1c2-t45">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t45" headers="r1c1-t45"> <p>?????????</p> </td> <td align="left" headers="r2c1-t45 r1c2-t45"> <p><code>:SYSDATE_YYYYMMDD</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t45" headers="r1c1-t45"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t45 r1c2-t45"> <p><code>APEX_APPLICATION.G_SYSDATE (DATE DATATYPE)</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t45" headers="r1c1-t45"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t45 r1c2-t45"> <p><code>V('SYSDATE_YYYYMMDD')</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="BEICEJEA" name="BEICEJEA"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h2><a name="HTMDB25060" id="HTMDB25060"></a>WORKSPACE_IMAGES<a id="sthref257" name="sthref257"></a></h2> <p>?????????????????????????????????????????????????????????????????????????°?????avaScript???????????????????????????????????<a href="#BEIEEHGB">????ORKSPACE_IMAGES?????</a>????<code>WORKSPACE_IMAGES</code>??????????????????????????????????????</p> <div class="tblformal"><a id="sthref258" name="sthref258"></a><a id="BEIEEHGB" name="BEIEEHGB"></a> <p class="titleintable">WORKSPACE_IMAGES???</p> <table class="Formal" title="WORKSPACE_IMAGES???" summary="??????????ORKSPACE_IMAGES??????????????????????????????????????" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="35%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t46">????????</th> <th align="left" valign="bottom" id="r1c2-t46">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t46" headers="r1c1-t46"> <p>?????????</p> </td> <td align="left" headers="r2c1-t46 r1c2-t46"> <p><code>:WORKSPACE_IMAGES</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t46" headers="r1c1-t46"> <p>???PL/SQL</p> </td> <td align="left" headers="r3c1-t46 r1c2-t46"> <p>??????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t46" headers="r1c1-t46"> <p>PL/SQL</p> </td> <td align="left" headers="r4c1-t46 r1c2-t46"> <p><code>V('WORKSPACE_IMAGES')</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t46" headers="r1c1-t46"> <p>????????</p> </td> <td align="left" headers="r5c1-t46 r1c2-t46"> <p><code>&WORKSPACE_IMAGES.</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t46" headers="r1c1-t46"> <p>????????????</p> </td> <td align="left" headers="r6c1-t46 r1c2-t46"> <p><code>#WORKSPACE_IMAGES#</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <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">???:</p> <a href="#BEIDCGAJ">??PP_IMAGES??</a>?????<a href="#BEIGJJBG">??MAGE_PREFIX??</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <!-- 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="concept_sub_using.htm"><img src="dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="bldr.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