Go to main content
1/712
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Changes in This Release
Changes in Oracle Application Express Release 18.1
New Features
Deprecated and Desupported Features
1
APEX_APPLICATION
1.1
Global Variables
1.2
Referencing Arrays
1.3
Referencing Values Within an On Submit Process
1.4
Converting an Array to a Single Value
1.5
HELP Procedure
1.6
STOP_APEX_ENGINE Procedure
2
APEX_ACL
2.1
ADD_USER_ROLE Procedure Signature 1
2.2
ADD_USER_ROLE Procedure Signature 2
2.3
HAS_USER_ANY_ROLES Function
2.4
HAS_USER_ROLE Function
2.5
REMOVE_USER_ROLE Procedure Signature 1
2.6
REMOVE_USER_ROLE Procedure Signature 2
2.7
REPLACE_USER_ROLES Procedure Signature 1
2.8
REPLACE_USER_ROLES Procedure Signature 2
2.9
REMOVE_ALL_USER_ROLES Procedure
3
APEX_APPLICATION_INSTALL
3.1
Package Overview
3.2
Attributes Manipulated by APEX_APPLICATION_INSTALL
3.3
Import Script Examples
3.4
CLEAR_ALL Procedure
3.5
GENERATE_APPLICATION_ID Procedure
3.6
GENERATE_OFFSET Procedure
3.7
GET_APPLICATION_ALIAS Function
3.8
GET_APPLICATION_ID Function
3.9
GET_APPLICATION_NAME Function
3.10
GET_AUTO_INSTALL_SUP_OBJ Function
3.11
GET_IMAGE_PREFIX Function
3.12
GET_KEEP_SESSIONS Function
3.13
GET_NO_PROXY_DOMAINS Function
3.14
GET_OFFSET Function
3.15
GET_PROXY Function
3.16
GET_REMOTE_SERVER_BASE_URL Function
3.17
GET_REMOTE_SERVER_HTTPS_HOST Function
3.18
GET_SCHEMA Function
3.19
GET_WORKSPACE_ID Function
3.20
SET_APPLICATION_ALIAS Procedure
3.21
SET_APPLICATION_ID Procedure
3.22
SET_APPLICATION_NAME Procedure
3.23
SET_AUTO_INSTALL_SUP_OBJ Procedure
3.24
SET_IMAGE_PREFIX Procedure
3.25
SET_KEEP_SESSIONS Procedure
3.26
SET_OFFSET Procedure
3.27
SET_PROXY Procedure
3.28
SET_REMOTE_SERVER Procedure
3.29
SET_SCHEMA Procedure
3.30
SET_WORKSPACE_ID Procedure
3.31
SET_WORKSPACE_Procedure
4
APEX_AUTHENTICATION
4.1
Constants
4.2
CALLBACK Procedure
4.3
GET_CALLBACK_URL Function
4.4
GET_LOGIN_USERNAME_COOKIE Function
4.5
IS_AUTHENTICATED Function
4.6
IS_PUBLIC_USER Function
4.7
LOGIN Procedure
4.8
LOGOUT Procedure
4.9
POST_LOGIN Procedure
4.10
SEND_LOGIN_USERNAME_COOKIE Procedure
5
APEX_AUTHORIZATION
5.1
ENABLE_DYNAMIC_GROUPS Procedure
5.2
IS_AUTHORIZED Function
5.3
RESET_CACHE Procedure
6
APEX_COLLECTION
6.1
About the APEX_COLLECTION API
6.2
Naming Collections
6.3
Creating a Collection
6.4
About the Parameter p_generate_md5
6.5
Accessing a Collection
6.6
Merging Collections
6.7
Truncating a Collection
6.8
Deleting a Collection
6.9
Deleting All Collections for the Current Application
6.10
Deleting All Collections in the Current Session
6.11
Adding Members to a Collection
6.12
About the Parameters p_generate_md5, p_clob001, p_blob001, and p_xmltype001
6.13
Updating Collection Members
6.14
Deleting Collection Members
6.15
Obtaining a Member Count
6.16
Resequencing a Collection
6.17
Verifying Whether a Collection Exists
6.18
Adjusting a Member Sequence ID
6.19
Sorting Collection Members
6.20
Clearing Collection Session State
6.21
Determining Collection Status
6.22
ADD_MEMBER Procedure
6.23
ADD_MEMBER Function
6.24
ADD_MEMBERS Procedure
6.25
COLLECTION_EXISTS Function
6.26
COLLECTION_HAS_CHANGED Function
6.27
COLLECTION_MEMBER_COUNT Function
6.28
CREATE_COLLECTION Procedure
6.29
CREATE_OR_TRUNCATE_COLLECTION Procedure
6.30
CREATE_COLLECTION_FROM_QUERY Procedure
6.31
CREATE_COLLECTION_FROM_QUERY2 Procedure
6.32
CREATE_COLLECTION_FROM_QUERY_B Procedure
6.33
CREATE_COLLECTION_FROM_QUERY_B Procedure (No bind version)
6.34
CREATE_COLLECTION_FROM_QUERYB2 Procedure
6.35
CREATE_COLLECTION_FROM_QUERYB2 Procedure (No bind version)
6.36
DELETE_ALL_COLLECTIONS Procedure
6.37
DELETE_ALL_COLLECTIONS_SESSION Procedure
6.38
DELETE_COLLECTION Procedure
6.39
DELETE_MEMBER Procedure
6.40
DELETE_MEMBERS Procedure
6.41
GET_MEMBER_MD5 Function
6.42
MERGE_MEMBERS Procedure
6.43
MOVE_MEMBER_DOWN Procedure
6.44
MOVE_MEMBER_UP Procedure
6.45
RESEQUENCE_COLLECTION Procedure
6.46
RESET_COLLECTION_CHANGED Procedure
6.47
RESET_COLLECTION_CHANGED_ALL Procedure
6.48
SORT_MEMBERS Procedure
6.49
TRUNCATE_COLLECTION Procedure
6.50
UPDATE_MEMBER Procedure
6.51
UPDATE_MEMBERS Procedure
6.52
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 1
6.53
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 2
6.54
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3
6.55
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 4
6.56
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
6.57
UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6
7
APEX_APP_SETTING
7.1
SET_VALUE Procedure
7.2
GET_VALUE Function
8
APEX_CSS
8.1
ADD Procedure
8.2
ADD_3RD_PARTY_LIBRARY_FILE Procedure
8.3
ADD_FILE Procedure
9
APEX_CUSTOM_AUTH
9.1
APPLICATION_PAGE_ITEM_EXISTS Function
9.2
CURRENT_PAGE_IS_PUBLIC Function
9.3
DEFINE_USER_SESSION Procedure
9.4
GET_COOKIE_PROPS Procedure
9.5
GET_LDAP_PROPS Procedure
9.6
GET_NEXT_SESSION_ID Function
9.7
GET_SECURITY_GROUP_ID Function
9.8
GET_SESSION_ID Function
9.9
GET_SESSION_ID_FROM_COOKIE Function
9.10
GET_USER Function
9.11
GET_USERNAME Function
9.12
IS_SESSION_VALID Function
9.13
LOGIN Procedure
9.14
LOGOUT Procedure [DEPRECATED]
9.15
POST_LOGIN Procedure
9.16
SESSION_ID_EXISTS Function
9.17
SET_SESSION_ID Procedure
9.18
SET_SESSION_ID_TO_NEXT_VALUE Procedure
9.19
SET_USER Procedure
10
APEX_DEBUG
10.1
Constants
10.2
DISABLE Procedure
10.3
DISABLE_DBMS_OUTPUT Procedure
10.4
ENABLE Procedure
10.5
ENTER Procedure
10.6
ENABLE_DBMS_OUTPUT Procedure
10.7
ERROR Procedure
10.8
INFO Procedure
10.9
LOG_DBMS_OUTPUT Procedure
10.10
LOG_LONG_MESSAGE Procedure
10.11
LOG_MESSAGE Procedure [Deprecated]
10.12
LOG_PAGE_SESSION_STATE Procedure
10.13
MESSAGE Procedure
10.14
REMOVE_DEBUG_BY_AGE Procedure
10.15
REMOVE_DEBUG_BY_APP Procedure
10.16
REMOVE_DEBUG_BY_VIEW Procedure
10.17
REMOVE_SESSION_MESSAGES Procedure
10.18
TOCHAR Function
10.19
TRACE Procedure
10.20
WARN Procedure
11
APEX_ESCAPE
11.1
Constants
11.2
HTML Function
11.3
HTML_ATTRIBUTE Function
11.4
HTML_TRUNC Function
11.5
HTML_WHITELIST Function
11.6
JS_LITERAL Function
11.7
JSON Function
11.8
LDAP_DN Function
11.9
LDAP_SEARCH_FILTER Function
11.10
NOOP Function
11.11
REGEXP Function
11.12
SET_HTML_ESCAPING_MODE Procedure
12
APEX_ERROR
12.1
Constants and Attributes used for Result Types
12.2
Example of an Error Handling Function
12.3
ADD_ERROR Procedure Signature 1
12.4
ADD_ERROR Procedure Signature 2
12.5
ADD_ERROR Procedure Signature 3
12.6
ADD_ERROR Procedure Signature 4
12.7
ADD_ERROR Procedure Signature 5
12.8
APEX_ERROR.HAVE_ERRORS_OCCURRED Function
12.9
AUTO_SET_ASSOCIATED_ITEM Procedure
12.10
EXTRACT_CONSTRAINT_NAME Function
12.11
GET_FIRST_ORA_ERROR_TEXT Function
12.12
INIT_ERROR_RESULT Function
13
APEX_EXEC
13.1
Global Constants
13.2
Data Types
13.3
ADD_COLUMN Procedure
13.4
ADD_FILTER Procedure
13.5
ADD_ORDER_BY Procedure
13.6
ADD_PARAMETER Procedure
13.7
CLOSE Procedure
13.8
EXECUTE_PLSQL Procedure
13.9
EXECUTE_REMOTE_PLSQL Procedure
13.10
EXECUTE_WEB_SOURCE Procedure
13.11
GET Functions
13.12
GET_COLUMN Function
13.13
GET_COLUMN_COUNT Function
13.14
GET_COLUMN_POSITION Function
13.15
GET_PARAMETER Functions
13.16
GET_TOTAL_ROW_COUNT Function
13.17
IS_REMOTE_SQL_AUTH_VALID Function
13.18
NEXT_ROW Function
13.19
OPEN_REMOTE_SQL_QUERY Function
13.20
OPEN_QUERY_CONTEXT Function
13.21
OPEN_WEB_SOURCE_QUERY Function
13.22
PURGE_WEB_SOURCE _CACHE Procedure
14
APEX_EXPORT
14.1
GET_APPLICATION Function
14.2
GET_WORKSPACE _FILES Function
14.3
GET_FEEDBACK Function
14.4
GET_WORKSPACE Function
15
APEX_INSTANCE_ADMIN
15.1
Available Parameter Values
15.2
ADD_SCHEMA Procedure
15.3
ADD_WORKSPACE Procedure
15.4
CREATE_SCHEMA_EXCEPTION Procedure
15.5
FREE_WORKSPACE_APP_IDS Procedure
15.6
GET_PARAMETER Function
15.7
GET_SCHEMAS Function
15.8
GET_WORKSPACE_PARAMETER
15.9
REMOVE_APPLICATION Procedure
15.10
REMOVE_SAVED_REPORT Procedure
15.11
REMOVE_SAVED_REPORTS Procedure
15.12
REMOVE_SCHEMA Procedure
15.13
REMOVE_SCHEMA_EXCEPTION Procedure
15.14
REMOVE_SCHEMA_EXCEPTIONS Procedure
15.15
REMOVE_SUBSCRIPTION Procedure
15.16
REMOVE_WORKSPACE Procedure
15.17
REMOVE_WORKSPACE_EXCEPTIONS Procedure
15.18
RESERVE_WORKSPACE_APP_IDS Procedure
15.19
RESTRICT_SCHEMA Procedure
15.20
SET_LOG_SWITCH_INTERVAL Procedure
15.21
SET_WORKSPACE_PARAMETER
15.22
SET_PARAMETER Procedure
15.23
SET_WORKSPACE_CONSUMER_GROUP Procedure
15.24
TRUNCATE_LOG Procedure
15.25
UNRESTRICT_SCHEMA Procedure
16
APEX_IR
16.1
ADD_FILTER Procedure Signature 1
16.2
ADD_FILTER Procedure Signature 2
16.3
CHANGE_SUBSCRIPTION_EMAIL Procedure
16.4
CHANGE_REPORT_OWNER Procedure
16.5
CHANGE_SUBSCRIPTION_EMAIL Procedure
16.6
CHANGE_SUBSCRIPTION_LANG Procedure
16.7
CLEAR_REPORT Procedure Signature 1
16.8
CLEAR_REPORT Procedure Signature 2
16.9
DELETE_REPORT Procedure
16.10
DELETE_SUBSCRIPTION Procedure
16.11
GET_LAST_VIEWED_REPORT_ID Function
16.12
GET_REPORT Function
16.13
RESET_REPORT Procedure Signature 1
16.14
RESET_REPORT Procedure Signature 2
17
APEX_ITEM
17.1
CHECKBOX2 Function
17.2
DATE_POPUP Function
17.3
DATE_POPUP2 Function
17.4
DISPLAY_AND_SAVE Function
17.5
HIDDEN Function
17.6
MD5_CHECKSUM Function
17.7
MD5_HIDDEN Function
17.8
POPUP_FROM_LOV Function
17.9
POPUP_FROM_QUERY Function
17.10
POPUPKEY_FROM_LOV Function
17.11
POPUPKEY_FROM_QUERY Function
17.12
RADIOGROUP Function
17.13
SELECT_LIST Function
17.14
SELECT_LIST_FROM_LOV Function
17.15
SELECT_LIST_FROM_LOV_XL Function
17.16
SELECT_LIST_FROM_QUERY Function
17.17
SELECT_LIST_FROM_QUERY_XL Function
17.18
SWITCH Function
17.19
TEXT Function
17.20
TEXTAREA Function
17.21
TEXT_FROM_LOV Function
17.22
TEXT_FROM_LOV_QUERY Function
18
APEX_JAVASCRIPT
18.1
ADD_3RD_PARTY_LIBRARY_FILE Procedure
18.2
ADD_ATTRIBUTE Function Signature 1
18.3
ADD_ATTRIBUTE Function Signature 2
18.4
ADD_ATTRIBUTE Function Signature 3
18.5
ADD_ATTRIBUTE Function Signature 4
18.6
ADD_INLINE_CODE Procedure
18.7
ADD_LIBRARY Procedure
18.8
ADD_REQUIREJS Procedure
18.9
ADD_REQUIREJS_DEFINE Procedure
18.10
ADD_ONLOAD_CODE Procedure
18.11
ADD_VALUE Function Signature 1
18.12
ADD_VALUE Function Signature 2
18.13
ADD_VALUE Function Signature 3
18.14
ADD_VALUE Function Signature 4
18.15
Escape Function
19
APEX_JSON
19.1
Package Overview and Examples
19.2
Constants and Data Types
19.3
CLOSE_ALL Procedure
19.4
CLOSE_ARRAY Procedure
19.5
CLOSE_OBJECT Procedure
19.6
DOES_EXIST Function
19.7
FIND_PATHS_LIKE Function
19.8
FREE_OUTPUT Procedure
19.9
FLUSH Procedure
19.10
GET_BOOLEAN Function
19.11
GET_CLOB_OUTPUT Function
19.12
GET_COUNT Function
19.13
GET_DATE Function
19.14
GET_MEMBERS Function
19.15
GET_NUMBER Function
19.16
GET_VALUE Function
19.17
GET_T_NUMBER Function
19.18
GET_T_VARCHAR2 Function
19.19
GET_VARCHAR2 Function
19.20
GET_CLOB Function
19.21
INITIALIZE_CLOB_OUTPUT Procedure
19.22
INITIALIZE_OUTPUT Procedure
19.23
OPEN_ARRAY Procedure
19.24
OPEN_OBJECT Procedure
19.25
PARSE Procedure Signature 1
19.26
PARSE Procedure Signature 2
19.27
STRINGIFY Function Signature 1
19.28
STRINGIFY Function Signature 2
19.29
STRINGIFY Function Signature 3
19.30
STRINGIFY Function Signature 4
19.31
TO_MEMBER_NAME Function
19.32
TO_XMLTYPE Function
19.33
TO_XMLTYPE_SQL Function
19.34
WRITE Procedure Signature 1
19.35
WRITE Procedure Signature 2
19.36
WRITE Procedure Signature 3
19.37
WRITE Procedure Signature 4
19.38
WRITE Procedure Signature 5
19.39
WRITE Procedure Signature 6
19.40
WRITE Procedure Signature 7
19.41
WRITE Procedure Signature 8
19.42
WRITE Procedure Signature 9
19.43
WRITE Procedure Signature 10
19.44
WRITE Procedure Signature 11
19.45
WRITE Procedure Signature 12
19.46
WRITE Procedure Signature 13
19.47
WRITE Procedure Signature 14
19.48
WRITE Procedure Signature 15
19.49
WRITE Procedure Signature 16
19.50
WRITE Procedure Signature 17
19.51
WRITE Procedure Signature 18
20
APEX_JWT
20.1
T_TOKEN
20.2
ENCODE Function
20.3
DECODE Function
20.4
VALIDATE Procedure
21
APEX_LANG
21.1
CREATE_LANGUAGE_MAPPING Procedure
21.2
DELETE_LANGUAGE_MAPPING Procedure
21.3
EMIT_LANGUAGE_SELECTOR_LIST Procedure
21.4
LANG Function
21.5
MESSAGE Function
21.6
PUBLISH_APPLICATION Procedure
21.7
SEED_TRANSLATIONS Procedure
21.8
UPDATE_LANGUAGE_MAPPING Procedure
21.9
UPDATE_MESSAGE Procedure
21.10
UPDATE_TRANSLATED_STRING Procedure
22
APEX_LDAP
22.1
AUTHENTICATE Function
22.2
GET_ALL_USER_ATTRIBUTES Procedure
22.3
GET_USER_ATTRIBUTES Procedure
22.4
IS_MEMBER Function
22.5
MEMBER_OF Function
22.6
MEMBER_OF2 Function
22.7
SEARCH Function
23
APEX_MAIL
23.1
Configuring Oracle Application Express to Send Email
23.2
ADD_ATTACHMENT Procedure
23.3
GET_IMAGES_URL Function
23.4
GET_INSTANCE_URL Function
23.5
PREPARE_TEMPLATE Procedure
23.6
PUSH_QUEUE Procedure
23.7
SEND Procedure
23.8
SEND Function
23.9
SEND Procedure
23.10
SEND Function
24
APEX_PKG_APP_INSTALL
24.1
DEINSTALL Procedure Signature 1
24.2
DEINSTALL Procedure Signature 2
24.3
INSTALL Function Signature 1
24.4
INSTALL Function Signature 2
24.5
UPGRADE Procedure Signature 1
24.6
UPGRADE Procedure Signature 2
25
APEX_PAGE
25.1
Global Constants
25.2
IS_DESKTOP_UI Function
25.3
IS_JQM_SMARTPHONE_UI Function
25.4
IS_JQM_TABLET_UI Function
25.5
GET_UI_TYPE Function
25.6
IS_READ_ONLY Function
25.7
GET_PAGE_MODE Function
25.8
PURGE_CACHE Procedure
25.9
GET_URL Function
26
APEX_PLUGIN
26.1
Data Types
26.2
GET_AJAX_IDENTIFIER Function
26.3
GET_INPUT_NAME_FOR_PAGE_ITEM Function
27
APEX_PLUGIN_UTIL
27.1
CLEAR_COMPONENT_VALUES Procedure
27.2
DEBUG_DYNAMIC _ACTION Procedure
27.3
DEBUG_PAGE_ITEM Procedure Signature 1
27.4
DEBUG_PAGE_ITEM Procedure Signature 2
27.5
DEBUG_PROCESS Procedure
27.6
DEBUG_REGION Procedure Signature 1
27.7
DEBUG_REGION Procedure Signature 2
27.8
ESCAPE Function
27.9
EXECUTE_PLSQL_CODE Procedure
27.10
GET_ATTRIBUTE_AS_NUMBER Function
27.11
GET_DATA Function Signature 1
27.12
GET_DATA Function Signature 2
27.13
GET_DATA2 Function Signature 1
27.14
GET_DATA2 Function Signature 2
27.15
GET_DISPLAY_DATA Function Signature 1
27.16
GET_DISPLAY_DATA Function Signature 2
27.17
GET_ELEMENT_ATTRIBUTES Function
27.18
GET_PLSQL_EXPRESSION_RESULT Function
27.19
GET_PLSQL_FUNCTION_RESULT Function
27.20
GET_POSITION_IN_LIST Function
27.21
GET_SEARCH_STRING Function
27.22
GET_VALUE_AS_VARCHAR2 Function
27.23
IS_EQUAL Function
27.24
PAGE_ITEM_NAMES_TO_JQUERY Function
27.25
PRINT_DISPLAY_ONLY Procedure
27.26
PRINT_ESCAPED_VALUE Procedure
27.27
PRINT_HIDDEN_IF_READONLY Procedure
27.28
PRINT_JSON_HTTP_HEADER Procedure
27.29
PRINT_LOV_AS_JSON Procedure
27.30
PRINT_OPTION Procedure
27.31
REPLACE_SUBSTITUTIONS Function
27.32
SET_COMPONENT_VALUES Procedure
28
APEX_REGION
28.1
IS_READ_ONLY Function
28.2
PURGE_CACHE Procedure
29
APEX_SESSION
29.1
SET_DEBUG Procedure
29.2
SET_TRACE Procedure
29.3
CREATE_SESSION Procedure
29.4
DELETE_SESSION Procedure
29.5
ATTACH Procedure
29.6
DETACH Procedure
30
APEX_SPATIAL
30.1
Data Types
30.2
CHANGE_GEOM_METADATA Procedure
30.3
CIRCLE_POLYGON Function
30.4
DELETE_GEOM_METADATA Procedure
30.5
INSERT_GEOM_METADATA Procedure
30.6
INSERT_GEOM_METADATA_LONLAT Procedure
30.7
POINT Function
30.8
RECTANGLE Function
31
APEX_STRING
31.1
FORMAT Function
31.2
GET_INITIALS Function
31.3
GREP Function Signature 1
31.4
GREP Function Signature 2
31.5
GREP Function Signature 3
31.6
JOIN_CLOB Function
31.7
JOIN Function Signature 1
31.8
JOIN Function Signature 2
31.9
PLIST_DELETE Procedure
31.10
PLIST_GET Function
31.11
PLIST_PUT Function
31.12
PUSH Procedure Signature 1
31.13
PUSH Procedure Signature 2
31.14
PUSH Procedure Signature 3
31.15
SHUFFLE Function
31.16
SHUFFLE Procedure
31.17
SPLIT Function Signature 1
31.18
SPLIT Function Signature 2
31.19
SPLIT_NUMBERS Function
32
APEX_THEME
32.1
CLEAR_ALL_USERS_STYLE Procedure
32.2
CLEAR_USER_STYLE Procedure
32.3
DISABLE_USER_STYLE Procedure
32.4
ENABLE_USER_STYLE Procedure
32.5
GET_USER_STYLE Function
32.6
SET_CURRENT_STYLE Procedure
32.7
SET_SESSION_STYLE Procedure
32.8
SET_SESSION_STYLE_CSS Procedure
32.9
SET_USER_STYLE Procedure
33
APEX_UI_DEFAULT_UPDATE
33.1
ADD_AD_COLUMN Procedure
33.2
ADD_AD_SYNONYM Procedure
33.3
DEL_AD_COLUMN Procedure
33.4
DEL_AD_SYNONYM Procedure
33.5
DEL_COLUMN Procedure
33.6
DEL_GROUP Procedure
33.7
DEL_TABLE Procedure
33.8
SYNCH_TABLE Procedure
33.9
UPD_AD_COLUMN Procedure
33.10
UPD_AD_SYNONYM Procedure
33.11
UPD_COLUMN Procedure
33.12
UPD_DISPLAY_IN_FORM Procedure
33.13
UPD_DISPLAY_IN_REPORT Procedure
33.14
UPD_FORM_REGION_TITLE Procedure
33.15
UPD_GROUP Procedure
33.16
UPD_ITEM_DISPLAY_HEIGHT Procedure
33.17
UPD_ITEM_DISPLAY_WIDTH Procedure
33.18
UPD_ITEM_FORMAT_MASK Procedure
33.19
UPD_ITEM_HELP Procedure
33.20
UPD_LABEL Procedure
33.21
UPD_REPORT_ALIGNMENT Procedure
33.22
UPD_REPORT_FORMAT_MASK Procedure
33.23
UPD_REPORT_REGION_TITLE Procedure
33.24
UPD_TABLE Procedure
34
APEX_UTIL
34.1
CACHE_GET_DATE_OF_PAGE_CACHE Function
34.2
CACHE_GET_DATE_OF_REGION_CACHE Function
34.3
CACHE_PURGE_BY_APPLICATION Procedure
34.4
CACHE_PURGE_BY_PAGE Procedure
34.5
CACHE_PURGE_STALE Procedure
34.6
CHANGE_CURRENT_USER_PW Procedure
34.7
CHANGE_PASSWORD_ON_FIRST_USE Function
34.8
CLOSE_OPEN_DB_LINKS Procedure
34.9
CLEAR_APP_CACHE Procedure
34.10
CLEAR_PAGE_CACHE Procedure
34.11
CLEAR_USER_CACHE Procedure
34.12
COUNT_CLICK Procedure
34.13
CREATE_USER Procedure
34.14
CREATE_USER_GROUP Procedure
34.15
CURRENT_USER_IN_GROUP Function
34.16
CUSTOM_CALENDAR Procedure
34.17
DELETE_USER_GROUP Procedure Signature 1
34.18
DELETE_USER_GROUP Procedure Signature 2
34.19
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1
34.20
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2
34.21
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3
34.22
DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4
34.23
EDIT_USER Procedure
34.24
END_USER_ACCOUNT_DAYS_LEFT Function
34.25
EXPIRE_END_USER_ACCOUNT Procedure
34.26
EXPIRE_WORKSPACE_ACCOUNT Procedure
34.27
EXPORT_USERS Procedure
34.28
FETCH_APP_ITEM Function
34.29
FETCH_USER Procedure Signature 1
34.30
FETCH_USER Procedure Signature 2
34.31
FETCH_USER Procedure Signature 3
34.32
FIND_SECURITY_GROUP_ID Function
34.33
FIND_WORKSPACE Function
34.34
GET_ACCOUNT_LOCKED_STATUS Function
34.35
GET_APPLICATION_STATUS Function
34.36
GET_ATTRIBUTE Function
34.37
GET_AUTHENTICATION_RESULT Function
34.38
GET_BLOB_FILE_SRC Function
34.39
GET_BUILD_OPTION_STATUS Function Signature 1
34.40
GET_BUILD_OPTION_STATUS Function Signature 2
34.41
GET_CURRENT_USER_ID Function
34.42
GET_DEFAULT_SCHEMA Function
34.43
GET_EDITION Function
34.44
GET_EMAIL Function
34.45
GET_FEEDBACK_FOLLOW_UP Function
34.46
GET_FILE Procedure
34.47
GET_FILE_ID Function
34.48
GET_FIRST_NAME Function
34.49
GET_GLOBAL_NOTIFICATION Function
34.50
GET_GROUPS_USER_BELONGS_TO Function
34.51
GET_GROUP_ID Function
34.52
GET_GROUP_NAME Function
34.53
GET_HASH Function
34.54
GET_HIGH_CONTRAST_MODE_TOGGLE Function
34.55
GET_LAST_NAME Function
34.56
GET_NUMERIC_SESSION_STATE Function
34.57
GET_PREFERENCE Function
34.58
GET_PRINT_DOCUMENT Function Signature 1
34.59
GET_PRINT_DOCUMENT Function Signature 2
34.60
GET_PRINT_DOCUMENT Function Signature 3
34.61
GET_PRINT_DOCUMENT Function Signature 4
34.62
GET_SCREEN_READER_MODE_TOGGLE Function
34.63
GET_SESSION_LANG Function
34.64
GET_SESSION_STATE Function
34.65
GET_SESSION_TERRITORY Function
34.66
GET_SESSION_TIME_ZONE Function
34.67
GET_SINCE Function
34.68
GET_SUPPORTING_OBJECT_SCRIPT Function
34.69
GET_SUPPORTING_OBJECT_SCRIPT Procedure
34.70
GET_USER_ID Function
34.71
GET_USER_ROLES Function
34.72
GET_USERNAME Function
34.73
HOST_URL Function
34.74
HTML_PCT_GRAPH_MASK Function
34.75
INCREMENT_CALENDAR Procedure
34.76
IR_CLEAR Procedure [DEPRECATED]
34.77
IR_DELETE_REPORT Procedure [DEPRECATED]
34.78
IR_DELETE_SUBSCRIPTION Procedure [DEPRECATED]
34.79
IR_FILTER Procedure [DEPRECATED]
34.80
IR_RESET Procedure [DEPRECATED]
34.81
IS_HIGH_CONTRAST_SESSION Function
34.82
IS_HIGH_CONTRAST_SESSION_YN Function
34.83
IS_LOGIN_PASSWORD_VALID Function
34.84
IS_SCREEN_READER_SESSION Function
34.85
IS_SCREEN_READER_SESSION_YN Function
34.86
IS_USERNAME_UNIQUE Function
34.87
KEYVAL_NUM Function
34.88
KEYVAL_VC2 Function
34.89
LOCK_ACCOUNT Procedure
34.90
PASSWORD_FIRST_USE_OCCURRED Function
34.91
PREPARE_URL Function
34.92
PUBLIC_CHECK_AUTHORIZATION Function [DEPRECATED]
34.93
PURGE_REGIONS_BY_APP Procedure
34.94
PURGE_REGIONS_BY_NAME Procedure
34.95
PURGE_REGIONS_BY_PAGE Procedure
34.96
REDIRECT_URL Procedure
34.97
REMOVE_PREFERENCE Procedure
34.98
REMOVE_SORT_PREFERENCES Procedure
34.99
REMOVE_USER Procedure
34.100
RESET_AUTHORIZATIONS Procedure [DEPRECATED]
34.101
RESET_PASSWORD Procedure
34.102
RESET_PW Procedure
34.103
SAVEKEY_NUM Function
34.104
SAVEKEY_VC2 Function
34.105
SET_APP_BUILD_STATUS Procedure
34.106
SET_APPLICATION_STATUS Procedure
34.107
SET_ATTRIBUTE Procedure
34.108
SET_AUTHENTICATION_RESULT Procedure
34.109
SET_BUILD_OPTION_STATUS Procedure
34.110
SET_CURRENT_THEME_STYLE Procedure [DEPRECATED]
34.111
SET_CUSTOM_AUTH_STATUS Procedure
34.112
SET_EDITION Procedure
34.113
SET_EMAIL Procedure
34.114
SET_FIRST_NAME Procedure
34.115
SET_GLOBAL_NOTIFICATION Procedure
34.116
SET_GROUP_GROUP_GRANTS Procedure
34.117
SET_GROUP_USER_GRANTS Procedure
34.118
SET_LAST_NAME Procedure
34.119
SET_PARSING_SCHEMA_FOR _REQUEST Procedure
34.120
SET_PREFERENCE Procedure
34.121
SET_SECURITY_GROUP_ID Procedure
34.122
SET_SESSION_HIGH_CONTRAST_OFF Procedure
34.123
SET_SESSION_HIGH_CONTRAST_ON Procedure
34.124
SET_SESSION_LANG Procedure
34.125
SET_SESSION_LIFETIME_SECONDS Procedure
34.126
SET_SESSION_MAX_IDLE_SECONDS Procedure
34.127
SET_SESSION_SCREEN_READER_OFF Procedure
34.128
SET_SESSION_SCREEN_READER_ON Procedure
34.129
SET_SESSION_STATE Procedure
34.130
SET_SESSION_TERRITORY Procedure
34.131
SET_SESSION_TIME_ZONE Procedure
34.132
SET_USERNAME Procedure
34.133
SET_WORKSPACE_Procedure
34.134
SHOW_HIGH_CONTRAST_MODE_TOGGLE Procedure
34.135
SHOW_SCREEN_READER_MODE_TOGGLE Procedure
34.136
STRING_TO_TABLE Function [DEPRECATED]
34.137
STRONG_PASSWORD_CHECK Procedure
34.138
STRONG_PASSWORD_VALIDATION Function
34.139
SUBMIT_FEEDBACK Procedure
34.140
SUBMIT_FEEDBACK_FOLLOWUP Procedure
34.141
TABLE_TO_STRING Function [DEPRECATED]
34.142
UNEXPIRE_END_USER_ACCOUNT Procedure
34.143
UNEXPIRE_WORKSPACE_ACCOUNT Procedure
34.144
UNLOCK_ACCOUNT Procedure
34.145
URL_ENCODE Function
34.146
WORKSPACE_ACCOUNT_DAYS_LEFT Function
35
APEX_WEB_SERVICE
35.1
About the APEX_WEB_SERVICE API
35.2
Invoking a SOAP Style Web Service
35.3
Invoking a RESTful Style Web Service
35.4
Retrieving Cookies and HTTP Headers
35.5
Setting Cookies and HTTP Headers
35.6
BLOB2CLOBBASE64 Function
35.7
CLOBBASE642BLOB Function
35.8
MAKE_REQUEST Procedure
35.9
MAKE_REQUEST Function
35.10
MAKE_REST_REQUEST Function
35.11
MAKE_REST_REQUEST_B Function
35.12
OAUTH_AUTHENTICATE Function
35.13
OAUTH_GET_LAST_TOKEN Function
35.14
OAUTH_SET_TOKEN Function
35.15
PARSE_RESPONSE Function
35.16
PARSE_RESPONSE_CLOB Function
35.17
PARSE_XML Function
35.18
PARSE_XML_CLOB Function
36
APEX_ZIP
36.1
Data Types
36.2
ADD_FILE Procedure
36.3
FINISH Procedure
36.4
GET_FILE_CONTENT Function
36.5
GET_FILES Function
37
JavaScript APIs
37.1
apex namespace
37.1.1
About apex.confirm Function
37.1.2
apex.confirm Signature 1
37.1.3
apex.confirm Signature 2
37.1.4
apex.gPageContext$ Property
37.1.5
apex.jQuery Property
37.1.6
About apex.submit Function
37.1.7
apex.submit Signature 1
37.1.8
apex.submit Signature 2
37.2
apex.da namespace
37.2.1
apex.da.resume
37.3
apex.debug namespace
37.3.1
Log Level Constants
37.3.2
apex.debug.error
37.3.3
apex.debug.getLevel
37.3.4
apex.debug.info
37.3.5
apex.debug.log
37.3.6
apex.debug.message
37.3.7
apex.debug.setLevel
37.3.8
apex.debug.trace
37.3.9
apex.debug.warn
37.4
apex.event namespace
37.4.1
apex.event.trigger
37.5
apex.item
37.5.1
apex.item
37.5.2
addValue
37.5.3
disable
37.5.4
displayValueFor
37.5.5
enable
37.5.6
getValidity
37.5.7
getValidationMessage
37.5.8
getValue
37.5.9
hide
37.5.10
isChanged
37.5.11
isDisabled
37.5.12
isEmpty
37.5.13
Item Object Properties
37.5.14
setFocus
37.5.15
setStyle
37.5.16
setValue
37.5.17
show
37.5.18
apex.item.create
37.6
apex.lang namespace
37.6.1
apex.lang.addMessages
37.6.2
apex.lang.clearMessages
37.6.3
apex.lang.format
37.6.4
apex.lang.formatMessage
37.6.5
apex.lang.formatMessageNoEscape
37.6.6
apex.lang.formatNoEscape
37.6.7
apex.lang.getMessage
37.7
apex.message namespace
37.7.1
apex.message.addVisibilityCheck
37.7.2
apex.message.alert
37.7.3
apex.message.clearErrors
37.7.4
apex.message.confirm
37.7.5
apex.message.hidePageSuccess
37.7.6
apex.message.setThemeHooks
37.7.7
apex.message.showErrors
37.7.8
apex.message.showPageSuccess
37.7.9
apex.message.TYPE
37.8
apex.navigation namespace
37.8.1
apex.navigation.dialog
37.8.2
apex.navigation.dialog.cancel
37.8.3
apex.navigation.dialog.close
37.8.4
apex.navigation.dialog.fireCloseHandler
37.8.5
apex.navigation.dialog.registerCloseHandler
37.8.6
apex.navigation.openInNewWindow
37.8.7
apex.navigation.popup
37.8.8
apex.navigation.popup.close
37.8.9
apex.navigation.redirect
37.9
apex.page namespace
37.9.1
apex.page.cancelWarnOnUnsavedChanges
37.9.2
apex.page.confirm Signature 1
37.9.3
apex.page.confirm Signature 2
37.9.4
apex.page.submit Signature 1
37.9.5
apex.page.submit Signature 2
37.9.6
apex.page.validate
37.9.7
apex.page.isChanged
37.9.8
apex.page.warnOnUnsavedChanges
37.10
apex.region
37.10.1
apex.region
37.10.1.1
focus
37.10.1.2
refresh
37.10.1.3
widget
37.10.2
apex.region.create
37.10.3
apex.region.destroy
37.10.4
apex.region.isRegion
37.10.5
apex.region.findClosest
37.11
apex.server namespace
37.11.1
apex.server.loadScript
37.11.2
apex.server.plugin
37.11.3
apex.server.pluginUrl
37.11.4
apex.server.process
37.11.5
apex.server.url
37.12
apex.storage namespace
37.12.1
About local and session storage
37.12.2
apex.storage.getCookie
37.12.3
apex.storage.hasLocalStorageSupport
37.12.4
apex.storage.getScopedLocalStorage
37.12.5
apex.storage.getScopedSessionStorage
37.12.6
apex.storage.hasSessionStorageSupport
37.12.7
apex.storage.setCookie
37.13
apex.util namespace
37.13.1
apex.util.escapeCSS
37.13.2
apex.util.escapeHTML
37.13.3
apex.util.showSpinner
37.13.4
apex.util.stripHTML
37.13.5
apex.util.applyTemplate
37.13.6
About apex.util.delayLinger
37.13.7
apex.util.delayLinger.start
37.13.8
apex.util.delayLinger.finish
37.14
apex.widget namespace
37.14.1
apex.widget.initPageItem
37.15
Events
37.15.1
apexafterclosedialog
37.15.2
apexafterrefresh
37.15.3
apexbeforerefresh
37.15.4
apexbeforepagesubmit
37.15.5
apexbeginrecordedit
37.15.6
apexendrecordedit
37.15.7
apexpagesubmit
37.15.8
apexwindowresized
37.16
Non-namespace JavaScript APIs
37.16.1
$x
37.16.2
$v
37.16.3
$v2
37.16.4
$s
37.16.5
$u_Narray
37.16.6
$u_Carray
37.16.7
$nvl
37.16.8
$x_Style
37.16.9
$x_Hide
37.16.10
$x_Show
37.16.11
$x_Toggle
37.16.12
$x_Remove
37.16.13
$x_Value
37.16.14
$x_UpTill
37.16.15
$x_ItemRow
37.16.16
$x_HideItemRow
37.16.17
$x_ShowItemRow
37.16.18
$x_ToggleItemRow
37.16.19
$x_HideAllExcept
37.16.20
$x_HideSiblings
37.16.21
$x_ShowSiblings
37.16.22
$x_Class
37.16.23
$x_SetSiblingsClass
37.16.24
$x_ByClass
37.16.25
$x_ShowAllByClass
37.16.26
$x_ShowChildren
37.16.27
$x_HideChildren
37.16.28
$x_disableItem
37.16.29
$f_get_emptys
37.16.30
$v_Array
37.16.31
$f_ReturnChecked
37.16.32
$d_ClearAndHide
37.16.33
$f_SelectedOptions
37.16.34
$f_SelectValue
37.16.35
$u_ArrayToString
37.16.36
$x_CheckImageSrc
37.16.37
$v_CheckValueAgainst
37.16.38
$f_Hide_On_Value_Item
37.16.39
$f_Show_On_Value_Item
37.16.40
$f_Hide_On_Value_Item_Row
37.16.41
$f_Show_On_Value_Item_Row
37.16.42
$f_DisableOnValue
37.16.43
$x_ClassByClass
37.16.44
$f_ValuesToArray
37.16.45
$x_FormItems
37.16.46
$f_CheckAll
37.16.47
$f_CheckFirstColumn
37.16.48
$x_ToggleWithImage
37.16.49
$x_SwitchImageSrc
37.16.50
$x_CheckImageSrc
37.16.51
$u_SubString
37.16.52
html_RemoveAllChildren
37.16.53
html_SetSelectValue
37.16.54
addLoadEvent
37.16.55
$f_Swap
37.16.56
$f_SetValueSequence
37.16.57
$dom_AddTag
37.16.58
$tr_AddTD
37.16.59
$tr_AddTH
37.16.60
$dom_AddInput
37.16.61
$dom_MakeParent
37.16.62
$x_RowHighlight
37.16.63
$x_RowHighlightOff
37.16.64
$v_Upper
37.16.65
$d_Find
37.16.66
$f_First_field
38
Using REST Administration Interface API
38.1
Authentication
38.2
Individual REST Services
38.2.1
Fetch Instance-Level Statistics
38.2.2
Fetch Workspace-Level Statistics
38.2.3
Application-Level Statistics
38.2.4
Instance Overview
38.2.5
REST Service Version Information
Index
Scripting on this page enhances content navigation, but does not change the content in any way.