Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util.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>APEX_UTIL</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:15Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content=" APEX_UTIL" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-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" title="Home" type="text/html" /> <link rel="up" href="apex_util.htm" title="APEX_UTIL" type="text/html" /> <link rel="prev" href="preface.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util001.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > APEX_UTIL</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="preface.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util001.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDIEDJH" name="CHDIEDJH"></a></p> <h1><a name="AEAPI101" id="AEAPI101"></a> APEX_UTIL</h1> <p>The <a id="sthref7" name="sthref7"></a><a id="sthref8" name="sthref8"></a><code>APEX_UTIL</code> package provides utilities you can use when programming in the Oracle Application Express environment. You can use the <code>APEX_UTIL</code> package to get and set session state, get files, check authorizations for users, reset different states for users, get and purge cache information and also to get and set preferences for users.</p> <p><a id="sthref9" name="sthref9"></a></p> <p class="subhead2">Topics:</p> <ul> <li> <p><a href="apex_util001.htm#CHDDHJHE">CACHE_GET_DATE_OF_PAGE_CACHE Function</a></p> </li> <li> <p><a href="apex_util002.htm#CHDFCGDF">CACHE_GET_DATE_OF_REGION_CACHE Function</a></p> </li> <li> <p><a href="apex_util003.htm#CHDECEGE">CACHE_PURGE_BY_APPLICATION Procedure</a></p> </li> <li> <p><a href="apex_util004.htm#CHDEGECD">CACHE_PURGE_BY_PAGE Procedure</a></p> </li> <li> <p><a href="apex_util005.htm#CHDJAFAB">CACHE_PURGE_STALE Procedure</a></p> </li> <li> <p><a href="apex_util006.htm#BABHDJHD">CHANGE_CURRENT_USER_PW Procedure</a></p> </li> <li> <p><a href="apex_util007.htm#CHDFJCDH">CHANGE_PASSWORD_ON_FIRST_USE Function</a></p> </li> <li> <p><a href="apex_util008.htm#CHDEGFII">CLEAR_APP_CACHE Procedure</a></p> </li> <li> <p><a href="apex_util009.htm#BABCIAFJ">CLEAR_PAGE_CACHE Procedure</a></p> </li> <li> <p><a href="apex_util010.htm#CHDIADIJ">CLEAR_USER_CACHE Procedure</a></p> </li> <li> <p><a href="apex_util011.htm#CHDBHDFF">COUNT_CLICK Procedure</a></p> </li> <li> <p><a href="apex_util012.htm#BABCFBGG">CREATE_USER Procedure</a></p> </li> <li> <p><a href="apex_util013.htm#BABCCAFG">CREATE_USER_GROUP Procedure</a></p> </li> <li> <p><a href="apex_util014.htm#BABHCBEG">CURRENT_USER_IN_GROUP Function</a></p> </li> <li> <p><a href="apex_util015.htm#CHDGFADB">DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1</a></p> </li> <li> <p><a href="apex_util016.htm#CHDHGFDA">DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2</a></p> </li> <li> <p><a href="apex_util017.htm#CHDGIFJD">DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3</a></p> </li> <li> <p><a href="apex_util018.htm#CHDFIGIJ">DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4</a></p> </li> <li> <p><a href="apex_util019.htm#BABGDGJH">EDIT_USER Procedure</a></p> </li> <li> <p><a href="apex_util020.htm#CHDGFAHB">END_USER_ACCOUNT_DAYS_LEFT Function</a></p> </li> <li> <p><a href="apex_util021.htm#CHDEGHHE">EXPIRE_END_USER_ACCOUNT Procedure</a></p> </li> <li> <p><a href="apex_util022.htm#CHDDBEEE">EXPIRE_WORKSPACE_ACCOUNT Procedure</a></p> </li> <li> <p><a href="apex_util023.htm#BABCDACJ">EXPORT_USERS Procedure</a></p> </li> <li> <p><a href="apex_util024.htm#BABIBAID">FETCH_APP_ITEM Function</a></p> </li> <li> <p><a href="apex_util025.htm#CHDJJGIB">FETCH_USER Procedure Signature 1</a></p> </li> <li> <p><a href="apex_util026.htm#CHDCEGHH">FETCH_USER Procedure Signature 2</a></p> </li> <li> <p><a href="apex_util027.htm#BABDAHCJ">FETCH_USER Procedure Signature 3</a></p> </li> <li> <p><a href="apex_util028.htm#BABBEIEJ">FIND_SECURITY_GROUP_ID Function</a></p> </li> <li> <p><a href="apex_util029.htm#BABFICHD">FIND_WORKSPACE Function</a></p> </li> <li> <p><a href="apex_util030.htm#CHDIFICC">GET_ACCOUNT_LOCKED_STATUS Function</a></p> </li> <li> <p><a href="apex_util031.htm#BABJAHCE">GET_ATTRIBUTE Function</a></p> </li> <li> <p><a href="apex_util032.htm#CHDICEAJ">GET_AUTHENTICATION_RESULT Function</a></p> </li> <li> <p><a href="apex_util033.htm#CHDICGDA">GET_BLOB_FILE_SRC Function</a></p> </li> <li> <p><a href="apex_util034.htm#BABCHECD">GET_CURRENT_USER_ID Function</a></p> </li> <li> <p><a href="apex_util035.htm#BABIEDHD">GET_DEFAULT_SCHEMA Function</a></p> </li> <li> <p><a href="apex_util036.htm#BABGIEJC">GET_EMAIL Function</a></p> </li> <li> <p><a href="apex_util037.htm#CHDHEEAF">GET_FILE Procedure</a></p> </li> <li> <p><a href="apex_util038.htm#CHDICJGD">GET_FILE_ID Function</a></p> </li> <li> <p><a href="apex_util039.htm#BABFFJGB">GET_FIRST_NAME Function</a></p> </li> <li> <p><a href="apex_util040.htm#BABGHFGB">GET_GROUPS_USER_BELONGS_TO Function</a></p> </li> <li> <p><a href="apex_util041.htm#BABFECFJ">GET_GROUP_ID Function</a></p> </li> <li> <p><a href="apex_util042.htm#BABIDGGD">GET_GROUP_NAME Function</a></p> </li> <li> <p><a href="apex_util043.htm#BABCAAGG">GET_LAST_NAME Function</a></p> </li> <li> <p><a href="apex_util044.htm#CHDBHEAD">GET_NUMERIC_SESSION_STATE Function</a></p> </li> <li> <p><a href="apex_util045.htm#CHDJJBGI">GET_PREFERENCE Function</a></p> </li> <li> <p><a href="apex_util046.htm#CHDDECIA">GET_PRINT_DOCUMENT Function Signature 1</a></p> </li> <li> <p><a href="apex_util047.htm#CHDHDDFI">GET_PRINT_DOCUMENT Function Signature 2</a></p> </li> <li> <p><a href="apex_util048.htm#CHDJBJCF">GET_PRINT_DOCUMENT Function Signature 3</a></p> </li> <li> <p><a href="apex_util049.htm#CHDCABJF">GET_PRINT_DOCUMENT Function Signature 4</a></p> </li> <li> <p><a href="apex_util050.htm#CHDEJEJE">GET_SESSION_STATE Function</a></p> </li> <li> <p><a href="apex_util051.htm#BABHDJCD">GET_USER_ID Function</a></p> </li> <li> <p><a href="apex_util052.htm#BABCHEEH">GET_USER_ROLES Function</a></p> </li> <li> <p><a href="apex_util053.htm#BABDBCCD">GET_USERNAME Function</a></p> </li> <li> <p><a href="apex_util054.htm#BABEEGHB">IS_LOGIN_PASSWORD_VALID Function</a></p> </li> <li> <p><a href="apex_util055.htm#BABBFADB">IS_USERNAME_UNIQUE Function</a></p> </li> <li> <p><a href="apex_util056.htm#CDECGAHI">KEYVAL_NUM Function</a></p> </li> <li> <p><a href="apex_util057.htm#CDEGEDHJ">KEYVAL_VC2 Function</a></p> </li> <li> <p><a href="apex_util058.htm#CHDGCCHI">LOCK_ACCOUNT Procedure</a></p> </li> <li> <p><a href="apex_util059.htm#CHDGCDII">PASSWORD_FIRST_USE_OCCURRED Function</a></p> </li> <li> <p><a href="apex_util060.htm#CDEIBCJD">PREPARE_URL Function</a></p> </li> <li> <p><a href="apex_util061.htm#CHDJHBFJ">PUBLIC_CHECK_AUTHORIZATION Function</a></p> </li> <li> <p><a href="apex_util062.htm#CHDEJJJH">PURGE_REGIONS_BY_APP Procedure</a></p> </li> <li> <p><a href="apex_util063.htm#CHDICGBE">PURGE_REGIONS_BY_NAME Procedure</a></p> </li> <li> <p><a href="apex_util064.htm#CHDGAGJA">PURGE_REGIONS_BY_PAGE Procedure</a></p> </li> <li> <p><a href="apex_util065.htm#CHDIBDEC">REMOVE_PREFERENCE Procedure</a></p> </li> <li> <p><a href="apex_util066.htm#CHDHDFHB">REMOVE_SORT_PREFERENCES Procedure</a></p> </li> <li> <p><a href="apex_util067.htm#BABCBJDG">REMOVE_USER Procedure</a></p> </li> <li> <p><a href="apex_util068.htm#CHDHBBFF">RESET_AUTHORIZATIONS Procedure</a></p> </li> <li> <p><a href="apex_util069.htm#BABHJDHG">RESET_PW Procedure</a></p> </li> <li> <p><a href="apex_util070.htm#CDECCEAJ">SAVEKEY_NUM Function</a></p> </li> <li> <p><a href="apex_util071.htm#CDEIHDAA">SAVEKEY_VC2 Function</a></p> </li> <li> <p><a href="apex_util072.htm#CDEJDGEF">SET_ATTRIBUTE Procedure</a></p> </li> <li> <p><a href="apex_util073.htm#CHDCAECI">SET_AUTHENTICATION_RESULT Procedure</a></p> </li> <li> <p><a href="apex_util074.htm#CHDHHJGJ">SET_CUSTOM_AUTH_STATUS Procedure</a></p> </li> <li> <p><a href="apex_util075.htm#BABFCJDC">SET_EMAIL Procedure</a></p> </li> <li> <p><a href="apex_util076.htm#BABEFBED">SET_FIRST_NAME Procedure</a></p> </li> <li> <p><a href="apex_util077.htm#BABIGGEF">SET_LAST_NAME Procedure</a></p> </li> <li> <p><a href="apex_util078.htm#CHDJDCAC">SET_PREFERENCE Procedure</a></p> </li> <li> <p><a href="apex_util079.htm#CHDDHJAH">SET_SESSION_LIFETIME_SECONDS Procedure</a></p> </li> <li> <p><a href="apex_util080.htm#CHDGBIJH">SET_SESSION_MAX_IDLE_SECONDS Procedure</a></p> </li> <li> <p><a href="apex_util081.htm#CHDBGEEC">SET_SESSION_STATE Procedure</a></p> </li> <li> <p><a href="apex_util082.htm#BABIBIBH">SET_USERNAME Procedure</a></p> </li> <li> <p><a href="apex_util083.htm#CHDDHGCB">STRONG_PASSWORD_CHECK Procedure</a></p> </li> <li> <p><a href="apex_util084.htm#CHDCIGBH">STRONG_PASSWORD_VALIDATION Function</a></p> </li> <li> <p><a href="apex_util085.htm#CHDFEEJD">STRING_TO_TABLE Function</a></p> </li> <li> <p><a href="apex_util086.htm#CHDJBFHG">TABLE_TO_STRING Function</a></p> </li> <li> <p><a href="apex_util087.htm#CHDEDBIF">UNEXPIRE_END_USER_ACCOUNT Procedure</a></p> </li> <li> <p><a href="apex_util088.htm#CHDFDFDH">UNEXPIRE_WORKSPACE_ACCOUNT Procedure</a></p> </li> <li> <p><a href="apex_util089.htm#CHDBFABJ">UNLOCK_ACCOUNT Procedure</a></p> </li> <li> <p><a href="apex_util090.htm#CHDHEFFG">URL_ENCODE Function</a></p> </li> <li> <p><a href="apex_util091.htm#CHDHBAEH">WORKSPACE_ACCOUNT_DAYS_LEFT Function</a></p> </li> </ul> <!-- 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="preface.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util001.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