Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Changes in This Release
• APEX_ACL
  • ADD_USER_ROLE Procedure Signature 1
  • ADD_USER_ROLE Procedure Signature 2
  • HAS_USER_ANY_ROLES Function
  • HAS_USER_ROLE Function
  • IS_ROLE_REMOVED_FROM_USER Function
  • REMOVE_USER_ROLE Procedure Signature 1
  • REMOVE_USER_ROLE Procedure Signature 2
  • REPLACE_USER_ROLES Procedure Signature 1
  • REPLACE_USER_ROLES Procedure Signature 2
  • REMOVE_ALL_USER_ROLES Procedure
• APEX_AI
  • Constants and Data Types
  • CHAT Function Signature 1
  • CHAT Function Signature 2
  • CHAT Function Signature 3 (Deprecated)
  • GENERATE Function Signature 1
  • GENERATE Function Signature 2
  • GENERATE Function Signature 3 (Deprecated)
  • GET_AVAILABLE_TOKENS Function
  • GET_VECTOR_EMBEDDINGS Function Signature 1
  • GET_VECTOR_EMBEDDINGS Function Signature 2
  • GET_VECTOR_EMBEDDINGS Function Signature 3
  • IS_ENABLED Function
  • IS_USER_CONSENT_NEEDED Function
  • REVOKE_USER_CONSENT Procedure
  • REVOKE_USER_CONSENT_FOR_ALL Procedure
  • SET_TOOL_RESULT Procedure Signature 1
  • SET_TOOL_RESULT Procedure Signature 2
  • SET_USER_CONSENT Procedure
• APEX_APP_OBJECT_DEPENDENCY
  • Constants
  • CLEAR_CACHE Procedure
  • SCAN Procedure
• APEX_APP_SETTING
  • GET_VALUE Function
  • SET_VALUE Procedure
• APEX_APPLICATION
  • Global Variables
  • HELP Procedure
  • STOP_APEX_ENGINE Procedure
• APEX_APPLICATION_ADMIN
  • Constants and Data Types
  • CREATE_WORKING_COPY Function
  • DEEP_SEC_IS_ENABLED Function
  • DEINSTALL_SUPPORTING_OBJECTS Procedure
  • GET_APPLICATION_ALIAS Function
  • GET_APPLICATION_NAME Function
  • GET_APPLICATION_STATUS Function
  • GET_APPLICATION_VERSION Function
  • GET_AUTHENTICATION_SCHEME Function
  • GET_BUILD_OPTION_STATUS Function Signature 1
  • GET_BUILD_OPTION_STATUS Function Signature 2
  • GET_BUILD_STATUS Function
  • GET_DEEP_SEC_APPLICATION_SCOPE Function
  • GET_DEEP_SEC_DB_RESOURCE_SCOPE Function
  • GET_GLOBAL_NOTIFICATION Function
  • GET_FILE_STORAGE Function
  • GET_IMAGE_PREFIX Function
  • GET_MAX_SCHEDULER_JOBS Function
  • GET_NO_PROXY_DOMAINS Function
  • GET_PARSING_SCHEMA Function
  • GET_PASS_ECID Function
  • GET_PROXY_SERVER Function
  • GET_SUPPORTING_OBJECTS_ERRORS Function
  • INSTALL_SUPPORTING_OBJECTS Procedure
  • LOCK_APPLICATION Procedure
  • SET_APPLICATION_ALIAS Procedure
  • SET_APPLICATION_NAME Procedure
  • SET_APPLICATION_STATUS Procedure
  • SET_APPLICATION_VERSION Procedure
  • SET_AUTHENTICATION_SCHEME Procedure
  • SET_BUILD_OPTION_STATUS Procedure Signature 1
  • SET_BUILD_OPTION_STATUS Procedure Signature 2
  • SET_BUILD_STATUS Procedure
  • SET_DEEP_SEC Procedure
  • SET_FILE_STORAGE Procedure
  • SET_GLOBAL_NOTIFICATION Procedure
  • SET_IMAGE_PREFIX Procedure
  • SET_MAX_SCHEDULER_JOBS Procedure
  • SET_PARSING_SCHEMA Procedure
  • SET_PASS_ECID Procedure
  • SET_PROXY_SERVER Procedure
  • SET_REMOTE_SERVER Procedure
  • UNLOCK_APPLICATION Procedure
• APEX_APPLICATION_INSTALL
  • Attributes Manipulated by APEX_APPLICATION_INSTALL
  • Import Data Types
  • Import Script Examples
  • ADD_DATA_REPORTER_REMAP Procedure
  • CLEAR_ALL Procedure
  • CLEAR_DATASET_IMPORT_MODES Procedure
  • CLEAR_DATA_REPORTER_REMAP Procedure
  • DEEP_SEC_IS_ENABLED Function
  • GENERATE_APPLICATION_ID Procedure
  • GENERATE_OFFSET Procedure
  • GET_APPLICATION_ALIAS Function
  • GET_APPLICATION_ID Function
  • GET_APPLICATION_NAME Function
  • GET_AUTHENTICATION_SCHEME Function
  • GET_AUTO_INSTALL_SUP_OBJ Function
  • GET_BUILD_STATUS Function
  • GET_DATA_REPORTER_REMAP Function
  • GET_DATASET_IMPORT_MODE Function
  • GET_DEEP_SEC_APPLICATION_SCOPE Function
  • GET_DEEP_SEC_DB_RESOURCE_SCOPE Function
  • GET_IMAGE_PREFIX Function
  • GET_INFO Function
  • GET_KEEP_BACKGROUND_EXECS Function
  • GET_KEEP_SESSIONS Function
  • GET_MAX_SCHEDULER_JOBS Function
  • GET_NO_PROXY_DOMAINS Function
  • GET_OFFSET Function
  • GET_PASS_ECID Function
  • GET_PROXY Function
  • GET_REMOTE_SERVER_AI_ATTRS Function
  • GET_REMOTE_SERVER_AI_HEADERS Function
  • GET_REMOTE_SERVER_AI_OCI_COMP Function
  • GET_REMOTE_SERVER_AI_OCI_ENDPT Function
  • GET_REMOTE_SERVER_AI_OCI_PROJ Function
  • GET_REMOTE_SERVER_AI_OCI_SRVMD Function
  • GET_REMOTE_SERVER_AI_MAXTOKENS Function
  • GET_REMOTE_SERVER_AI_MODEL Function
  • GET_REMOTE_SERVER_BASE_URL Function
  • GET_REMOTE_SERVER_DEFAULT_DB Function
  • GET_REMOTE_SERVER_HTTPS_HOST Function
  • GET_REMOTE_SERVER_SQL_MODE Function
  • GET_REST_SOURCE_CATALOG_GROUP Function
  • GET_SCHEMA Function
  • GET_SUBSCRIPTION_MAPPING Function
  • GET_SUBSCRIPTION_MODE Function
  • GET_THEME_ID Function
  • GET_WORKSPACE_ID Function
  • INSTALL Procedure
  • REMOVE_APPLICATION Procedure
  • SET_APPLICATION_ALIAS Procedure
  • SET_APPLICATION_ID Procedure
  • SET_APPLICATION_NAME Procedure
  • SET_AUTHENTICATION_SCHEME Procedure
  • SET_AUTO_INSTALL_SUP_OBJ Procedure
  • SET_BUILD_STATUS Function
  • SET_DATASET_IMPORT_MODE Procedure
  • SET_DEEP_SEC Procedure
  • SET_IMAGE_PREFIX Procedure
  • SET_KEEP_BACKGROUND_EXECS Procedure
  • SET_KEEP_SESSIONS Procedure
  • SET_MAX_SCHEDULER_JOBS Procedure
  • SET_OFFSET Procedure
  • SET_PASS_ECID Procedure
  • SET_PROXY Procedure
  • SET_REMOTE_SERVER Procedure
  • SET_REST_SOURCE_CATALOG_GROUP Procedure
  • SET_SCHEMA Procedure
  • SET_SUBSCRIPTION_MAPPING Procedure
  • SET_SUBSCRIPTION_MODE Procedure
  • SET_THEME_ID Procedure
  • SET_WORKSPACE_ID Procedure
  • SET_WORKSPACE Procedure
  • SUSPEND_BACKGROUND_EXECS Procedure
• APEX_APPROVAL (Deprecated)
  • Constants and Data Types
  • ADD_TASK_COMMENT Procedure
  • ADD_TASK_POTENTIAL_OWNER Procedure
  • ADD_TO_HISTORY Procedure
  • APPROVE_TASK Procedure
  • CANCEL_TASK Procedure
  • CLAIM_TASK Procedure
  • COMPLETE_TASK Procedure
  • CREATE_TASK Function
  • DELEGATE_TASK Procedure
  • GET_LOV_PRIORITY Function
  • GET_LOV_STATE Function
  • GET_NEXT_PURGE_TIMESTAMP Function
  • GET_TASK_DELEGATES Function
  • GET_TASK_HISTORY Function
  • GET_TASK_PARAMETER_OLD_VALUE Function
  • GET_TASK_PARAMETER_VALUE Function
  • GET_TASK_PRIORITIES Function
  • GET_TASKS Function
  • HANDLE_TASK_DEADLINES Procedure
  • HAS_TASK_PARAM_CHANGED Function
  • IS_ALLOWED Function
  • IS_BUSINESS_ADMIN Function
  • IS_OF_PARTICIPANT_TYPE Function
  • REJECT_TASK Procedure
  • RELEASE_TASK Procedure
  • REMOVE_POTENTIAL_OWNER Procedure
  • RENEW_TASK Function
  • REQUEST_MORE_INFORMATION Procedure
  • SET_INITIATOR_CAN_COMPLETE Procedure
  • SET_TASK_DUE Procedure
  • SET_TASK_PARAMETER_VALUES Procedure
  • SET_TASK_PRIORITY Procedure
  • SUBMIT_INFORMATION Procedure
• APEX_AUTHENTICATION
  • Constants
  • CALLBACK Procedure
  • CALLBACK2 Procedure
  • GET_CALLBACK_URL Function
  • GET_LOGIN_USERNAME_COOKIE Function
  • GROUPS_FROM_TOKEN Function
  • IS_AUTHENTICATED Function
  • IS_PUBLIC_USER Function
  • LOGIN Procedure
  • LOGOUT Procedure
  • PERSISTENT_AUTH_ENABLED Function
  • PERSISTENT_COOKIES_ENABLED Function
  • POST_LOGIN Procedure
  • REMOVE_CURRENT_PERSISTENT_AUTH Procedure
  • REMOVE_PERSISTENT_AUTH Procedure
  • SAML_CALLBACK Procedure
  • SAML_METADATA Procedure
  • SEND_LOGIN_USERNAME_COOKIE Procedure
• APEX_AUTHORIZATION
  • ENABLE_DYNAMIC_GROUPS Procedure
  • HAS_ACCESS Function
  • IS_AUTHORIZED Function
  • RESET_CACHE Procedure
• APEX_AUTOMATION
  • ABORT Procedure (Deprecated)
  • DISABLE Procedure
  • ENABLE Procedure
  • EXECUTE Procedure Signature 1
  • EXECUTE Procedure Signature 2
  • EXECUTE for Query Context Procedure
  • EXIT Procedure
  • GET_LAST_RUN Function
  • GET_LAST_RUN_TIMESTAMP Function
  • GET_SCHEDULER_JOB_NAME Function
  • IS_RUNNING Function
  • LOG_ERROR Procedure
  • LOG_INFO Procedure
  • LOG_WARN Procedure
  • RESCHEDULE Procedure
  • SKIP_CURRENT_ROW Procedure
  • TERMINATE Procedure
• APEX_BACKGROUND_PROCESS
  • Constants
  • Data Types
  • ABORT Procedure Signature 1 (Deprecated)
  • ABORT Procedure Signature 2 (Deprecated)
  • GET_CURRENT_EXECUTION Function
  • GET_EXECUTION Function
  • SET_PROGRESS Procedure
  • SET_STATUS Procedure
  • TERMINATE Procedure Signature 1
  • TERMINATE Procedure Signature 2
• APEX_BARCODE
  • GET_CODE128_PNG Function
  • GET_CODE128_SVG Function
  • GET_EAN8_PNG Function
  • GET_EAN8_SVG Function
  • GET_QRCODE_PNG Function
  • GET_QRCODE_SVG Function
• APEX_COLLECTION
  • ADD_MEMBER Procedure
  • ADD_MEMBER Function
  • ADD_MEMBERS Procedure
  • COLLECTION_EXISTS Function
  • COLLECTION_HAS_CHANGED Function
  • COLLECTION_MEMBER_COUNT Function
  • CREATE_COLLECTION Procedure
  • CREATE_COLLECTION_FROM_QUERY Procedure
  • CREATE_COLLECTION_FROM_QUERY2 Procedure
  • CREATE_COLLECTION_FROM_QUERY_B Procedure
  • CREATE_COLLECTION_FROM_QUERY_B Procedure (No bind version)
  • CREATE_COLLECTION_FROM_QUERYB2 Procedure
  • CREATE_COLLECTION_FROM_QUERYB2 Procedure (No bind version)
  • CREATE_OR_TRUNCATE_COLLECTION Procedure
  • DELETE_ALL_COLLECTIONS Procedure
  • DELETE_ALL_COLLECTIONS_SESSION Procedure
  • DELETE_COLLECTION Procedure
  • DELETE_MEMBER Procedure
  • DELETE_MEMBERS Procedure
  • GET_MEMBER_MD5 Function
  • MERGE_MEMBERS Procedure
  • MOVE_MEMBER_DOWN Procedure
  • MOVE_MEMBER_UP Procedure
  • RESEQUENCE_COLLECTION Procedure
  • RESET_COLLECTION_CHANGED Procedure
  • RESET_COLLECTION_CHANGED_ALL Procedure
  • SORT_MEMBERS Procedure
  • TRUNCATE_COLLECTION Procedure
  • UPDATE_MEMBER Procedure
  • UPDATE_MEMBERS Procedure
  • UPDATE_MEMBER_ATTRIBUTE Procedure Signature 1
  • UPDATE_MEMBER_ATTRIBUTE Procedure Signature 2
  • UPDATE_MEMBER_ATTRIBUTE Procedure Signature 3
  • UPDATE_MEMBER_ATTRIBUTE Procedure Signature 4
  • UPDATE_MEMBER_ATTRIBUTE Procedure Signature 5
  • UPDATE_MEMBER_ATTRIBUTE Procedure Signature 6
• APEX_CREDENTIAL
  • CLEAR_TOKENS Procedure
  • CREATE_CREDENTIAL Procedure Signature 1
  • CREATE_CREDENTIAL Procedure Signature 2
  • DROP_CREDENTIAL Procedure
  • SET_ALLOWED_URLS Procedure
  • SET_DATABASE_CREDENTIAL Procedure
  • SET_PERSISTENT_CREDENTIALS Procedure Signature 1
  • SET_PERSISTENT_CREDENTIALS Procedure Signature 2
  • SET_PERSISTENT_CREDENTIALS Procedure Signature 3
  • SET_PERSISTENT_TOKEN Procedure
  • SET_SCOPE Procedure
  • SET_SESSION_CREDENTIALS Procedure Signature 1
  • SET_SESSION_CREDENTIALS Procedure Signature 2
  • SET_SESSION_CREDENTIALS Procedure Signature 3
  • SET_SESSION_TOKEN Procedure
• APEX_CSS
  • ADD Procedure
  • ADD_3RD_PARTY_LIBRARY_FILE Procedure (Deprecated)
  • ADD_FILE Procedure
• APEX_CUSTOM_AUTH
  • APPLICATION_PAGE_ITEM_EXISTS Function
  • CURRENT_PAGE_IS_PUBLIC Function
  • DEFINE_USER_SESSION Procedure
  • GET_COOKIE_PROPS Procedure
  • GET_LDAP_PROPS Procedure
  • GET_NEXT_SESSION_ID Function
  • GET_SECURITY_GROUP_ID Function
  • GET_SESSION_ID Function
  • GET_SESSION_ID_FROM_COOKIE Function
  • GET_USER Function
  • GET_USERNAME Function
  • IS_SESSION_VALID Function
  • LDAP_DNPREP Function
  • LOGIN Procedure
  • LOGOUT Procedure (Deprecated)
  • POST_LOGIN Procedure
  • SESSION_ID_EXISTS Function
  • SET_SESSION_ID Procedure
  • SET_SESSION_ID_TO_NEXT_VALUE Procedure
  • SET_USER Procedure
• APEX_DATA_LOADING
  • Data Types
  • GET_FILE_PROFILE Function
  • LOAD_DATA Function Signature 1
  • LOAD_DATA Function Signature 2
• APEX_DATA_EXPORT
  • Global Constants
  • Data Types
  • ADD_AGGREGATE Procedure
  • ADD_COLUMN Procedure
  • ADD_COLUMN_GROUP Procedure
  • ADD_HIGHLIGHT Procedure
  • DOWNLOAD Procedure
  • EXPORT Function
  • GET_PRINT_CONFIG Function
• APEX_DATA_INSTALL
  • LOAD_SUPPORTING_OBJECT_DATA Procedure
• APEX_DATA_PARSER
  • Global Constants
  • Data Types
  • ASSERT_FILE_TYPE Function
  • DISCOVER Function
  • GET_COLUMNS Function
  • GET_FILE_PROFILE Function
  • GET_FILE_TYPE Function
  • GET_XLSX_WORKSHEETS Function
  • JSON_TO_PROFILE Function
  • PARSE Function
  • SET_PARSER_FLAGS Procedure
• APEX_DB_DICTIONARY
  • GET_METADATA Function
  • GET_PRIMARY_KEY_COLUMNS Function
  • GET_TABLE_INFO Function Signature 1
  • GET_TABLE_INFO Function Signature 2
  • GET_TABLE_INFO_REGEX Function
  • GET_TABLES_ARRAY Function
  • GET_TABLES_JSON Function
  • GET_TABLES_SUMMARY Function
  • FORMAT_METADATA Function Signature 1
  • FORMAT_METADATA Function Signature 2
  • IS_SUPPORTED Function
• APEX_DEBUG
  • Constants
  • DISABLE Procedure
  • DISABLE_DBMS_OUTPUT Procedure
  • ENABLE Procedure
  • ENTER Procedure
  • ENABLE_DBMS_OUTPUT Procedure
  • ERROR Procedure
  • GET_LAST_MESSAGE_ID Function
  • GET_PAGE_VIEW_ID Function
  • INFO Procedure
  • LOG_DBMS_OUTPUT Procedure
  • LOG_LONG_MESSAGE Procedure
  • LOG_MESSAGE Procedure (Deprecated)
  • LOG_PAGE_SESSION_STATE Procedure
  • MESSAGE Procedure
  • REMOVE_DEBUG_BY_AGE Procedure
  • REMOVE_DEBUG_BY_APP Procedure
  • REMOVE_DEBUG_BY_VIEW Procedure
  • REMOVE_SESSION_MESSAGES Procedure
  • TOCHAR Function
  • TRACE Procedure
  • WARN Procedure
• APEX_DG_DATA_GEN
  • ADD_BLUEPRINT Procedure
  • ADD_BLUEPRINT_FROM_FILE Procedure
  • ADD_BLUEPRINT_FROM_TABLES Procedure
  • ADD_COLUMN Procedure
  • ADD_DATA_SOURCE Procedure
  • ADD_TABLE Procedure
  • EXPORT_BLUEPRINT Function
  • GENERATE_DATA Procedure Signature 1
  • GENERATE_DATA Procedure Signature 2
  • GENERATE_DATA_INTO_COLLECTION Procedure
  • GET_BLUEPRINT_ID Function
  • GET_BP_TABLE_ID Function
  • GET_EXAMPLE Function
  • GET_WEIGHTED_INLINE_DATA Function
  • IMPORT_BLUEPRINT Procedure
  • PREVIEW_BLUEPRINT Procedure
  • REMOVE_BLUEPRINT Procedure
  • REMOVE_COLUMN Procedure
  • REMOVE_DATA_SOURCE Procedure
  • REMOVE_TABLE Procedure
  • RESEQUENCE_BLUEPRINT Procedure
  • STOP_DATA_GENERATION Procedure
  • UPDATE_BLUEPRINT Procedure
  • UPDATE_COLUMN Procedure
  • UPDATE_DATA_SOURCE Procedure
  • UPDATE_TABLE Procedure
  • VALIDATE_BLUEPRINT Procedure
  • VALIDATE_INSTANCE_SETTING Procedure
• APEX_ERROR
  • Constants and Attributes Used for Result Types
  • Example of an Error Handling Function
  • ADD_ERROR Procedure Signature 1
  • ADD_ERROR Procedure Signature 2
  • ADD_ERROR Procedure Signature 3
  • ADD_ERROR Procedure Signature 4
  • ADD_ERROR Procedure Signature 5
  • AUTO_SET_ASSOCIATED_ITEM Procedure
  • EXTRACT_CONSTRAINT_NAME Function
  • GET_FIRST_ORA_ERROR_TEXT Function
  • HAVE_ERRORS_OCCURRED Function
  • INIT_ERROR_RESULT Function
• APEX_ESCAPE
  • Constants
  • CSS_SELECTOR Function
  • CSV Function Signature 1
  • CSV Function Signature 2
  • GET_CSV_ENCLOSED_BY Function
  • GET_CSV_SEPARATED_BY Function
  • HTML Function
  • HTML_ALLOWLIST Function
  • HTML_ALLOWLIST_CLOB Function
  • HTML_ATTRIBUTE Function
  • HTML_ATTRIBUTE_CLOB Function
  • HTML_CLOB Function
  • HTML_TRUNC Function Signature 1
  • HTML_TRUNC Function Signature 2
  • JS_LITERAL Function
  • JS_LITERAL_CLOB Function
  • JSON Function
  • JSON_CLOB Function
  • LDAP_DN Function
  • LDAP_SEARCH_FILTER Function
  • NOOP Function Signature 1
  • NOOP Function Signature 2
  • REGEXP Function
  • SET_CSV_PARAMETERS Procedure
  • SET_HTML_ESCAPING_MODE Procedure
  • STRIPHTML Function Signature 1
  • STRIPHTML Function Signature 2
• APEX_EXEC
  • Call Sequences for APEX_EXEC
    • Querying a Data Source with APEX_EXEC
    • Executing a DML on a Data Source with APEX_EXEC
    • Executing a Remote Procedure or REST API with APEX_EXEC
  • Global Constants
  • Data Types
  • ADD_COLUMN Procedure
  • ADD_DML_ARRAY_ROW Procedure
  • ADD_DML_ROW Procedure
  • ADD_FILTER Procedures
  • ADD_ORDER_BY Procedure
  • ADD_PARAMETER Procedure
  • CLEAR_DML_ROWS Procedure
  • CLOSE Procedure
  • CLOSE_ARRAY Procedure
  • COLUMN_EXISTS Function
  • COPY_DATA Procedure
  • DESCRIBE_QUERY Function Signature 1
  • DESCRIBE_QUERY Function Signature 2
  • ENQUOTE_LITERAL Function
  • ENQUOTE_NAME Function
  • EXECUTE_DML Procedure
  • EXECUTE_PLSQL Procedure Signature 1
  • EXECUTE_PLSQL Procedure Signature 2
  • EXECUTE_REMOTE_PLSQL Procedure Signature 1
  • EXECUTE_REMOTE_PLSQL Procedure Signature 2
  • EXECUTE_REST_SOURCE Procedure Signature 1
  • EXECUTE_REST_SOURCE Procedure Signature 2
  • EXECUTE_WEB_SOURCE Procedure (Deprecated)
  • GET Function
  • GET_ARRAY_ROW_DML_OPERATION Function
  • GET_ARRAY_ROW_VERSION_CHECKSUM Function
  • GET_COLUMN Function
  • GET_COLUMNS Function
  • GET_COLUMN_COUNT Function
  • GET_COLUMN_POSITION Function
  • GET_DATA_TYPE Function
  • GET_DML_STATUS_CODE Function
  • GET_DML_STATUS_MESSAGE Function
  • GET_PARAMETER Functions
  • GET_ROW_VERSION_CHECKSUM Function
  • GET_TOTAL_ROW_COUNT Function
  • HAS_ERROR Function
  • HAS_MORE_ARRAY_ROWS Function
  • HAS_MORE_ROWS Function
  • IS_GROUP_END Function
  • IS_REMOTE_SQL_AUTH_VALID Function
  • NEXT_ARRAY_ROW Function
  • NEXT_ROW Function
  • OPEN_ARRAY Procedure Signature 1
  • OPEN_ARRAY Procedure Signature 2
  • OPEN_DUALITY_VIEW_DML_CONTEXT Function
  • OPEN_JSON_SOURCE_DML_CONTEXT Function
  • OPEN_LOCAL_DML_CONTEXT Function
  • OPEN_QUERY_CONTEXT Function Signature 1
  • OPEN_QUERY_CONTEXT Function Signature 2
  • OPEN_REMOTE_DML_CONTEXT Function
  • OPEN_REMOTE_SQL_QUERY Function
  • OPEN_REST_SOURCE_DML_CONTEXT Function
  • OPEN_REST_SOURCE_QUERY Function
  • OPEN_WEB_SOURCE_DML_CONTEXT Function (Deprecated)
  • OPEN_WEB_SOURCE_QUERY Function (Deprecated)
  • PURGE_DUALITY_VIEW_CACHE Procedure
  • PURGE_JSON_SOURCE_CACHE Procedure
  • PURGE_REST_SOURCE_CACHE Procedure
  • PURGE_WEB_SOURCE_CACHE Procedure (Deprecated)
  • RESUME_DEEP_SEC Procedure
  • SET_ARRAY_CURRENT_ROW Procedure
  • SET_ARRAY_ROW_VERSION_CHECKSUM Procedure
  • SET_CURRENT_ROW Procedure
  • SET_NULL Procedure
  • SET_ROW_VERSION_CHECKSUM Procedure
  • SET_VALUE Procedure
  • SET_VALUES Procedure
  • SUSPEND_DEEP_SEC Procedure
• APEX_EXPORT
  • Constants and Data Types
  • GET_APPLICATION Function
  • GET_FEEDBACK Function
  • GET_WORKSPACE Function
  • GET_WORKSPACE_FILES Function
  • UNZIP Function
  • ZIP Function
• APEX_EXTENSION
  • ADD_MENU_ENTRY Procedure
  • GET_BUILDER_LINK Function
  • GET_GRANTOR_WORKSPACE Function
  • REMOVE_MENU_ENTRY Procedure
  • SET_WORKSPACE Procedure Signature 1
  • SET_WORKSPACE Procedure Signature 2
• APEX_GENDEV
  • PROCESS_BLUEPRINT Procedure
• APEX_HTTP
  • DOWNLOAD Procedure Signature 1
  • DOWNLOAD Procedure Signature 2
• APEX_HUMAN_TASK
  • Constants and Data Types
  • ADD_TASK_COMMENT Procedure
  • ADD_TASK_POTENTIAL_OWNER Procedure
  • ADD_TO_HISTORY Procedure
  • APPROVE_TASK Procedure
  • CANCEL_TASK Procedure
  • CLAIM_TASK Procedure
  • COMPLETE_TASK Procedure
  • CREATE_TASK Function
  • DELEGATE_TASK Procedure
  • DELETE_TASKS Procedure
  • EXCLUDE_POTENTIAL_OWNER Procedure
  • GET_LOV_PRIORITY Function
  • GET_LOV_STATE Function
  • GET_LOV_TYPE Function
  • GET_NEXT_PURGE_TIMESTAMP Function
  • GET_TASK_DELEGATES Function
  • GET_TASK_HISTORY Function
  • GET_TASK_PARAMETER_OLD_VALUE Function
  • GET_TASK_PARAMETER_VALUE Function
  • GET_TASK_PRIORITIES Function
  • GET_TASKS Function
  • HANDLE_TASK_DEADLINES Procedure
  • HAS_TASK_PARAM_CHANGED Function
  • IS_ALLOWED Function
  • IS_BUSINESS_ADMIN Function
  • IS_OF_PARTICIPANT_TYPE Function
  • REFRESH_BUSINESS_ADMINS Procedure
  • REJECT_TASK Procedure
  • RELEASE_TASK Procedure
  • REMOVE_POTENTIAL_OWNER Procedure
  • RENEW_TASK Function
  • REQUEST_MORE_INFORMATION Procedure
  • SET_INITIATOR_CAN_COMPLETE Procedure
  • SET_TASK_DUE Procedure
  • SET_TASK_OUTCOME Procedure
  • SET_TASK_PARAMETER_VALUES Procedure
  • SET_TASK_PRIORITY Procedure
  • SUBMIT_INFORMATION Procedure
• APEX_INSTANCE_ADMIN
  • Available Parameter Values
  • ADD_AUTO_PROV_RESTRICTIONS Procedure
  • ADD_SCHEMA Procedure
  • ADD_WEB_ENTRY_POINT Procedure
  • ADD_WORKSPACE Procedure
  • CREATE_CLOUD_CREDENTIAL Procedure
  • CREATE_OR_UPDATE_ADMIN_USER Procedure
  • CREATE_SCHEMA_EXCEPTION Procedure
  • DB_SIGNATURE Function
  • DROP_CLOUD_CREDENTIAL Procedure
  • FREE_WORKSPACE_APP_IDS Procedure
  • GET_PARAMETER Function
  • GET_SCHEMAS Function
  • GET_WORKSPACE_PARAMETER Procedure
  • GRANT_EXTENSION_WORKSPACE Procedure
  • IS_DB_SIGNATURE_VALID Function
  • REMOVE_APPLICATION Procedure
  • REMOVE_AUTO_PROV_RESTRICTIONS Procedure
  • REMOVE_SAVED_REPORT Procedure
  • REMOVE_SAVED_REPORTS Procedure
  • REMOVE_SCHEMA Procedure
  • REMOVE_SCHEMA_EXCEPTION Procedure
  • REMOVE_SCHEMA_EXCEPTIONS Procedure
  • REMOVE_SUBSCRIPTION Procedure
  • REMOVE_WEB_ENTRY_POINT Procedure
  • REMOVE_WORKSPACE Procedure
  • REMOVE_WORKSPACE_EXCEPTIONS Procedure
  • RESERVE_WORKSPACE_APP_IDS Procedure
  • RESTRICT_SCHEMA Procedure
  • REVOKE_EXTENSION_WORKSPACE Procedure
  • SET_LOG_SWITCH_INTERVAL Procedure
  • SET_PARAMETER Procedure
  • SET_WORKSPACE_CONSUMER_GROUP Procedure
  • SET_WORKSPACE_PARAMETER Procedure
  • TRUNCATE_LOG Procedure
  • UNLOCK_USER Procedure
  • UNRESTRICT_SCHEMA Procedure
  • VALIDATE_EMAIL_CONFIG Procedure
• APEX_INSTANCE_DEBUG
  • DISABLE Procedure
  • ENABLE Procedure
  • IS_ENABLED Function
  • LIST_ACTIVITY Procedure
  • LIST_MESSAGES Procedure
  • LIST_PAGE_VIEWS Procedure
• APEX_IG
  • ADD_FILTER Procedure Signature 1
  • ADD_FILTER Procedure Signature 2 (Deprecated)
  • ADD_FILTER Procedure Signature 3
  • CHANGE_REPORT_OWNER Procedure
  • CLEAR_REPORT Procedure Signature 1
  • CLEAR_REPORT Procedure Signature 2
  • CLEAR_REPORT Procedure Signature 3
  • DELETE_REPORT Procedure
  • GET_LAST_VIEWED_REPORT_ID Function
  • RESET_REPORT Procedure Signature 1
  • RESET_REPORT Procedure Signature 2
  • RESET_REPORT Procedure Signature 3
• APEX_IR
  • Constants and Data Types
  • ADD_FILTER Procedure Signature 1
  • ADD_FILTER Procedure Signature 2
  • ADD_FILTER Procedure Signature 3
  • CHANGE_REPORT_OWNER Procedure
  • CHANGE_SUBSCRIPTION_EMAIL Procedure
  • CHANGE_SUBSCRIPTION_LANG Procedure
  • CLEAR_REPORT Procedure Signature 1
  • CLEAR_REPORT Procedure Signature 2
  • CLEAR_REPORT Procedure Signature 3
  • CLONE_REPORT Function
  • DELETE_REPORT Procedure
  • DELETE_SUBSCRIPTION Procedure
  • EXPORT_SAVED_REPORTS Function
  • GET_LAST_VIEWED_REPORT_ID Function
  • GET_REPORT Function (Deprecated)
  • IMPORT_SAVED_REPORTS Procedure
  • RESET_REPORT Procedure Signature 1
  • RESET_REPORT Procedure Signature 2
  • RESET_REPORT Procedure Signature 3
• APEX_ITEM (Legacy)
  • CHECKBOX2 Function
  • DATE_POPUP Function
  • DATE_POPUP2 Function
  • DISPLAY_AND_SAVE Function
  • HIDDEN Function
  • MD5_CHECKSUM Function
  • MD5_HIDDEN Function
  • POPUP_FROM_LOV Function
  • POPUP_FROM_QUERY Function
  • POPUPKEY_FROM_LOV Function
  • POPUPKEY_FROM_QUERY Function
  • RADIOGROUP Function
  • SELECT_LIST Function
  • SELECT_LIST_FROM_LOV Function
  • SELECT_LIST_FROM_LOV_XL Function
  • SELECT_LIST_FROM_QUERY Function
  • SELECT_LIST_FROM_QUERY_XL Function
  • SWITCH Function
  • TEXT Function
  • TEXTAREA Function
  • TEXT_FROM_LOV Function
  • TEXT_FROM_LOV_QUERY Function
• APEX_JAVASCRIPT
  • Data Types
  • ADD_3RD_PARTY_LIBRARY_FILE Procedure (Deprecated)
  • ADD_ATTRIBUTE Function Signature 1
  • ADD_ATTRIBUTE Function Signature 2
  • ADD_ATTRIBUTE Function Signature 3
  • ADD_ATTRIBUTE Function Signature 4
  • ADD_INLINE_CODE Procedure
  • ADD_JET Procedure
  • ADD_LIBRARY Procedure
  • ADD_REQUIREJS Procedure
  • ADD_REQUIREJS_DEFINE Procedure
  • ADD_ONLOAD_CODE Procedure
  • ADD_VALUE Function Signature 1
  • ADD_VALUE Function Signature 2
  • ADD_VALUE Function Signature 3
  • ADD_VALUE Function Signature 4
  • Escape Function
• APEX_JSON
  • APEX_JSON Overview and Examples
  • Constants and Data Types
  • CLOSE_ALL Procedure
  • CLOSE_ARRAY Procedure
  • CLOSE_OBJECT Procedure
  • DOES_EXIST Function
  • FIND_PATHS_LIKE Function
  • FLUSH Procedure
  • FREE_OUTPUT Procedure
  • GET_BOOLEAN Function
  • GET_CLOB Function
  • GET_CLOB_OUTPUT Function
  • GET_COUNT Function
  • GET_DATE Function
  • GET_MEMBERS Function
  • GET_NUMBER Function
  • GET_SDO_GEOMETRY Function
  • GET_T_NUMBER Function
  • GET_T_VARCHAR2 Function
  • GET_VALUE Function
  • GET_VALUE_KIND Function
  • GET_VARCHAR2 Function
  • INITIALIZE_CLOB_OUTPUT Procedure
  • INITIALIZE_OUTPUT Procedure
  • OPEN_ARRAY Procedure
  • OPEN_OBJECT Procedure
  • PARSE Procedure Signature 1
  • PARSE Procedure Signature 2
  • STRINGIFY Function Signature 1
  • STRINGIFY Function Signature 2
  • STRINGIFY Function Signature 3
  • STRINGIFY Function Signature 4
  • STRINGIFY Function Signature 5
  • TO_MEMBER_NAME Function
  • TO_XMLTYPE Function
  • TO_XMLTYPE_SQL Function
  • WRITE Procedure Signature 1
  • WRITE Procedure Signature 2
  • WRITE Procedure Signature 3
  • WRITE Procedure Signature 4
  • WRITE Procedure Signature 5
  • WRITE Procedure Signature 6
  • WRITE Procedure Signature 7
  • WRITE Procedure Signature 8
  • WRITE Procedure Signature 9
  • WRITE Procedure Signature 10
  • WRITE Procedure Signature 11
  • WRITE Procedure Signature 12
  • WRITE Procedure Signature 13
  • WRITE Procedure Signature 14
  • WRITE Procedure Signature 15
  • WRITE Procedure Signature 16
  • WRITE Procedure Signature 17
  • WRITE Procedure Signature 18
  • WRITE Procedure Signature 19
  • WRITE Procedure Signature 20
  • WRITE Procedure Signature 21
  • WRITE_CONTEXT Procedure
• APEX_JWT
  • t_token Record
  • ENCODE Function
  • DECODE Function
  • VALIDATE Procedure
• APEX_LANG
  • APPLY_XLIFF_DOCUMENT Procedure
  • CREATE_LANGUAGE_MAPPING Procedure
  • CREATE_MESSAGE Procedure
  • DELETE_LANGUAGE_MAPPING Procedure
  • DELETE_MESSAGE Procedure
  • EMIT_LANGUAGE_SELECTOR_LIST Procedure
  • EXPORT_TEXT_MESSAGES Function Signature 1
  • EXPORT_TEXT_MESSAGES Function Signature 2
  • GET_LANGUAGE_SELECTOR_LIST Function
  • GET_MESSAGE Function
  • GET_XLIFF_DOCUMENT Function
  • IMPORT_TEXT_MESSAGES Procedure Signature 1
  • IMPORT_TEXT_MESSAGES Procedure Signature 2
  • LANG Function
  • MESSAGE Function (Deprecated)
  • PUBLISH_APPLICATION Procedure
  • SEED_TRANSLATIONS Procedure
  • UPDATE_LANGUAGE_MAPPING Procedure
  • UPDATE_MESSAGE Procedure Signature 1
  • UPDATE_MESSAGE Procedure Signature 2
  • UPDATE_TRANSLATED_STRING Procedure
• APEX_LDAP
  • AUTHENTICATE Function
  • GET_ALL_USER_ATTRIBUTES Procedure
  • GET_USER_ATTRIBUTES Procedure
  • IS_MEMBER Function
  • MEMBER_OF Function
  • MEMBER_OF2 Function
  • SEARCH Function
• APEX_MAIL
  • ADD_ATTACHMENT Procedure Signature 1
  • ADD_ATTACHMENT Procedure Signature 2
  • GET_IMAGES_URL Function
  • GET_INSTANCE_URL Function
  • PREPARE_TEMPLATE Procedure
  • PUSH_QUEUE Procedure
  • SEND Function Signature 1
  • SEND Function Signature 2
  • SEND Procedure Signature 1
  • SEND Procedure Signature 2
• APEX_MARKDOWN
  • Constants
  • TO_HTML Function
• APEX_PAGE
  • Global Constants
  • GET_CACHE_DATE Function
  • GET_PAGE_MODE Function
  • GET_UI_TYPE Function (Deprecated)
  • GET_URL Function
  • IS_DESKTOP_UI Function (Deprecated)
  • IS_READ_ONLY Function
  • PURGE_CACHE Procedure
• APEX_PLUGIN
  • Constants
  • Data Types
    • Generic Data Types
      • t_escape_mode
      • t_plugin
      • t_plugin_attributes
    • AI Tools Data Types
      • t_ai_tool
      • t_ai_tool_exec_param
      • t_ai_tool_exec_result
      • t_ai_tool_render_param
      • t_ai_tool_render_result
    • Authentication Data Types
      • t_authentication
      • t_authentication_ajax_result
      • t_authentication_auth_result
      • t_authentication_inval_result
      • t_authentication_logout_result
      • t_authentication_sentry_result
    • Authorization Data Types
      • t_authorization
      • t_authorization_exec_result
    • Dynamic Action Data Types
      • t_dynamic_action
      • t_dynamic_action_ajax_param
      • t_dynamic_action_ajax_result
      • t_dynamic_action_render_param
      • t_dynamic_action_render_result
    • Item Data Types
      • c_inline_in_notification
      • c_inline_with_field
      • c_inline_with_field_and_notif
      • c_on_error_page
      • t_item
      • t_item_ajax_result
      • t_item_meta_data_result
      • t_item_render_param
      • t_item_render_result
      • t_item_validation_result
    • Process Data Types
      • t_process
      • t_process_exec_result
    • Region Data Types
      • t_region
      • t_region_ajax_result
      • t_region_column
      • t_region_columns
      • t_region_render_param
      • t_region_render_result
    • REST Source Data Types
      • t_remote_server_config
      • t_remote_server_info
      • t_web_source
      • t_web_source_capabilities
      • t_web_source_column
      • t_web_source_dml_params
      • t_web_source_dml_result
      • t_web_source_execute_result
      • t_web_source_discover_params
      • t_web_source_discover_result
      • t_web_source_fetch_params
      • t_web_source_fetch_result
      • t_web_source_operation
      • t_web_source_parameter
  • GET_AJAX_IDENTIFIER Function
  • GET_KEEP_BACKGROUND_EXECS Function
  • GET_INPUT_NAME_FOR_ITEM Function
  • GET_INPUT_NAME_FOR_PAGE_ITEM Function (Deprecated)
• APEX_PLUGIN_UTIL
  • BUILD_REQUEST_BODY Procedure
  • CLEAR_COMPONENT_VALUES Procedure
  • CURRENT_ROW_CHANGED Function
  • DB_OPERATION_ALLOWED Function
  • DEBUG_DYNAMIC_ACTION Procedure
  • DEBUG_PAGE_ITEM Procedure Signature 1 (Deprecated)
  • DEBUG_PAGE_ITEM Procedure Signature 2 (Deprecated)
  • DEBUG_PROCESS Procedure
  • DEBUG_REGION Procedure Signature 1
  • DEBUG_REGION Procedure Signature 2
  • ESCAPE Function
  • EXECUTE_PLSQL_CODE Procedure (Deprecated)
  • GET_ATTRIBUTE_AS_NUMBER Function
  • GET_CURRENT_DATABASE_TYPE Function
  • GET_DATA Function Signature 1
  • GET_DATA Function Signature 2
  • GET_DATA2 Function Signature 1
  • GET_DATA2 Function Signature 2
  • GET_DISPLAY_DATA Function Signature 1
  • GET_DISPLAY_DATA Function Signature 2
  • GET_ELEMENT_ATTRIBUTES Function
  • GET_HTML_ATTR Function
  • GET_ORDERBY_NULLS_SUPPORT Function
  • GET_PLSQL_EXPR_RESULT_BOOLEAN Function
  • GET_PLSQL_EXPR_RESULT_CLOB Function
  • GET_PLSQL_EXPRESSION_RESULT Function
  • GET_PLSQL_FUNC_RESULT_BOOLEAN Function
  • GET_PLSQL_FUNC_RESULT_CLOB Function
  • GET_PLSQL_FUNCTION_RESULT Function
  • GET_POSITION_IN_LIST Function (Deprecated)
  • GET_SEARCH_STRING Function
  • GET_VALUE_AS_VARCHAR2 Function
  • GET_WEB_SOURCE_OPERATION Function
  • IS_EQUAL Function
  • IS_COMPONENT_USED Function
  • MAKE_REST_REQUEST Procedure Signature 1
  • MAKE_REST_REQUEST Procedure Signature 2
  • PAGE_ITEM_NAMES_TO_JQUERY Function (Deprecated)
  • PARSE_REFETCH_RESPONSE Function
  • PRINT_DISPLAY_ONLY Procedure Signature 1 (Deprecated)
  • PRINT_DISPLAY_ONLY Procedure Signature 2 (Deprecated)
  • PRINT_ESCAPED_VALUE Procedure Signature 1
  • PRINT_ESCAPED_VALUE Procedure Signature 2
  • PRINT_HIDDEN Procedure
  • PRINT_HIDDEN_IF_READONLY Procedure
  • PRINT_JSON_HTTP_HEADER Procedure
  • PRINT_LOV_AS_JSON Procedure
  • PRINT_OPTION Procedure
  • PRINT_READ_ONLY Procedure Signature 1
  • PRINT_READ_ONLY Procedure Signature 2
  • PROCESS_DML_RESPONSE Procedure
  • REPLACE_SUBSTITUTIONS Function
  • SET_COMPONENT_VALUES Procedure
  • SPLIT_MUTLIPLE_VALUE_TO_TABLE Function
• APEX_PRINT
  • Constants
  • GENERATE_DOCUMENT Function Signature 1
  • GENERATE_DOCUMENT Function Signature 2
  • GENERATE_DOCUMENT Function Signature 3
  • GENERATE_DOCUMENT Function Signature 4
  • GENERATE_DOCUMENT Function Signature 5
  • GENERATE_DOCUMENT Function Signature 6
  • REMOVE_TEMPLATE Procedure
  • UPLOAD_TEMPLATE Function
• APEX_PWA
  • GENERATE_PUSH_CREDENTIALS Procedure
  • HAS_PUSH_SUBSCRIPTION Function
  • PUSH_QUEUE Procedure
  • SEND_PUSH_NOTIFICATION Procedure
  • SUBSCRIBE_PUSH_NOTIFICATIONS Procedure
  • UNSUBSCRIBE_PUSH_NOTIFICATIONS Procedure
• APEX_REGION
  • CLEAR Procedure Signature 1
  • CLEAR Procedure Signature 2
  • EXPORT_DATA Function
  • GET_CACHE_DATE Function
  • GET_ID Function Signature 1
  • GET_ID Function Signature 2
  • IS_READ_ONLY Function
  • OPEN_QUERY_CONTEXT Function Signature 1
  • OPEN_QUERY_CONTEXT Function Signature 2
  • PURGE_CACHE Procedure Signature 1
  • PURGE_CACHE Procedure Signature 2
  • RESET Procedure Signature 1
  • RESET Procedure Signature 2
• APEX_REST_SOURCE_SYNC
  • DISABLE Procedure
  • DYNAMIC_SYNCHRONIZE_DATA Procedure
  • ENABLE Procedure
  • GET_LAST_SYNC_TIMESTAMP Function
  • GET_SYNC_TABLE_DEFINITION_SQL Function
  • IS_RUNNING Function
  • RESCHEDULE Procedure
  • SYNCHRONIZE_DATA Procedure
  • SYNCHRONIZE_TABLE_DEFINITION Procedure
• APEX_SEARCH
  • QUERY_EXPERT_SEARCH Function
  • QUERY_SEARCH_ENGINE Function
  • SEARCH Function
• APEX_SESSION
  • ATTACH Procedure
  • CREATE_SESSION Procedure
  • DETACH Procedure
  • DELETE_SESSION Procedure
  • ENABLE_DEEP_SEC_DATA_ROLES Procedure
  • SET_DEBUG Procedure
  • SET_TENANT_ID Procedure
  • SET_TRACE Procedure
• APEX_SESSION_STATE
  • Global Constants
  • Data Types
  • GET_BOOLEAN Function
  • GET_CLOB Function
  • GET_NUMBER Function
  • GET_TIMESTAMP Function
  • GET_VALUE Function
  • GET_VARCHAR2 Function
  • SET_VALUE Procedure Signature 1
  • SET_VALUE Procedure Signature 2
  • SET_VALUE Procedure Signature 3
  • SET_VALUE Procedure Signature 4
• APEX_SHARED_COMPONENT
  • Global Constants
  • PUBLISH Procedure
  • REFRESH Procedure
• APEX_SPATIAL
  • Data Types
  • CHANGE_GEOM_METADATA Procedure
  • CIRCLE_POLYGON Function
  • DELETE_GEOM_METADATA Procedure
  • INSERT_GEOM_METADATA Procedure
  • INSERT_GEOM_METADATA_LONLAT Procedure
  • POINT Function
  • RECTANGLE Function
  • SPATIAL_IS_AVAILABLE Function
• APEX_STRING
  • FORMAT Function
  • GET_INITIALS Function
  • GET_SEARCHABLE_PHRASES Function
  • GREP Function Signature 1
  • GREP Function Signature 2
  • GREP Function Signature 3
  • INDEX_OF Function Signature 1
  • INDEX_OF Function Signature 2
  • JOIN_CLOB Function
  • JOIN_CLOBS Function
  • JOIN Function Signature 1
  • JOIN Function Signature 2
  • NEXT_CHUNK Function
  • PLIST_DELETE Procedure
  • PLIST_EXISTS Function
  • PLIST_GET Function
  • PLIST_GET_KEY Function
  • PLIST_PUSH Procedure
  • PLIST_PUT Function
  • PLIST_TO_JSON_CLOB Function
  • PUSH Procedure Signature 1
  • PUSH Procedure Signature 2
  • PUSH Procedure Signature 3
  • PUSH Procedure Signature 4
  • PUSH Procedure Signature 5
  • PUSH Procedure Signature 6
  • PUSH Procedure Signature 7
  • SHUFFLE Function
  • SHUFFLE Procedure
  • SPLIT Function Signature 1
  • SPLIT Function Signature 2
  • SPLIT_CLOBS Function
  • SPLIT_NUMBERS Function
  • STRING_TO_TABLE Function
  • TABLE_TO_CLOB Function
  • TABLE_TO_STRING Function
• APEX_STRING_UTIL
  • DIFF Function
  • FIND_EMAIL_ADDRESSES Function
  • FIND_EMAIL_FROM Function
  • FIND_EMAIL_SUBJECT Function
  • FIND_IDENTIFIERS Function
  • FIND_LINKS Function
  • FIND_PHRASES Function
  • FIND_TAGS Function
  • GET_DOMAIN Function
  • GET_FILE_EXTENSION Function
  • GET_SLUG Function
  • PHRASE_EXISTS Function
  • REPLACE_WHITESPACE Function
  • TO_DISPLAY_FILESIZE Function
• APEX_T_JAVASCRIPT_OBJECT
  • Constructor
  • APPEND Procedure Signature 1
  • APPEND Procedure Signature 2
  • APPEND Procedure Signature 3
  • APPEND Procedure Signature 4
  • APPEND Procedure Signature 5
  • APPEND Procedure Signature 6
  • APPEND Procedure Signature 7
  • APPEND_FUNCTION Procedure
  • APPEND_RAW Procedure
  • CLOSE_ARRAY Procedure
  • CLOSE_OBJECT Procedure
  • IS_NULL Function
  • OPEN_ARRAY Procedure
  • OPEN_OBJECT Procedure
  • PUT Procedure Signature 1
  • PUT Procedure Signature 2
  • PUT Procedure Signature 3
  • PUT Procedure Signature 4
  • PUT Procedure Signature 5
  • PUT Procedure Signature 6
  • PUT Procedure Signature 7
  • PUT_FUNCTION Procedure
  • PUT_RAW Procedure Signature 1
  • RESET Procedure
  • TO_CLOB Function
• APEX_THEME
  • CLEAR_ALL_USERS_STYLE Procedure
  • CLEAR_USER_STYLE Procedure
  • DISABLE_USER_STYLE Procedure
  • ENABLE_USER_STYLE Procedure
  • GET_USER_STYLE Function
  • SET_CURRENT_STYLE Procedure
  • SET_SESSION_STYLE Procedure
  • SET_SESSION_STYLE_CSS Procedure
  • SET_USER_STYLE Procedure
• APEX_UI_DEFAULT_UPDATE
  • ADD_AD_COLUMN Procedure
  • ADD_AD_SYNONYM Procedure
  • DEL_AD_COLUMN Procedure
  • DEL_AD_SYNONYM Procedure
  • DEL_COLUMN Procedure
  • DEL_GROUP Procedure
  • DEL_TABLE Procedure
  • SYNCH_TABLE Procedure
  • UPD_AD_COLUMN Procedure
  • UPD_AD_SYNONYM Procedure
  • UPD_COLUMN Procedure
  • UPD_DISPLAY_IN_FORM Procedure
  • UPD_DISPLAY_IN_REPORT Procedure
  • UPD_FORM_REGION_TITLE Procedure
  • UPD_GROUP Procedure
  • UPD_ITEM_DISPLAY_HEIGHT Procedure
  • UPD_ITEM_DISPLAY_WIDTH Procedure
  • UPD_ITEM_FORMAT_MASK Procedure
  • UPD_ITEM_HELP Procedure
  • UPD_LABEL Procedure
  • UPD_REPORT_ALIGNMENT Procedure
  • UPD_REPORT_FORMAT_MASK Procedure
  • UPD_REPORT_REGION_TITLE Procedure
  • UPD_TABLE Procedure
• APEX_UTIL
  • BLOB_TO_CLOB Function
  • CACHE_GET_DATE_OF_PAGE_CACHE Function
  • CACHE_GET_DATE_OF_REGION_CACHE Function
  • CACHE_PURGE_BY_APPLICATION Procedure
  • CACHE_PURGE_BY_PAGE Procedure
  • CACHE_PURGE_STALE Procedure
  • CHANGE_CURRENT_USER_PW Procedure
  • CHANGE_PASSWORD_ON_FIRST_USE Function
  • CLOB_TO_BLOB Function
  • CLOSE_OPEN_DB_LINKS Procedure
  • CLEAR_APP_CACHE Procedure
  • CLEAR_PAGE_CACHE Procedure
  • CLEAR_USER_CACHE Procedure
  • COUNT_CLICK Procedure
  • CREATE_USER Procedure
  • CREATE_USER_GROUP Procedure
  • CURRENT_USER_IN_GROUP Function
  • CUSTOM_CALENDAR Procedure (Deprecated)
  • DELETE_FEEDBACK Procedure
  • DELETE_FEEDBACK_ATTACHMENT Procedure
  • DELETE_USER_GROUP Procedure Signature 1
  • DELETE_USER_GROUP Procedure Signature 2
  • DOWNLOAD_PRINT_DOCUMENT Procedure Signature 1
  • DOWNLOAD_PRINT_DOCUMENT Procedure Signature 2
  • DOWNLOAD_PRINT_DOCUMENT Procedure Signature 3
  • DOWNLOAD_PRINT_DOCUMENT Procedure Signature 4
  • EDIT_USER Procedure
  • END_USER_ACCOUNT_DAYS_LEFT Function
  • EXPIRE_END_USER_ACCOUNT Procedure
  • EXPIRE_WORKSPACE_ACCOUNT Procedure
  • EXPORT_USERS Procedure
  • FEEDBACK_ENABLED Function
  • FETCH_APP_ITEM Function
  • FETCH_USER Procedure Signature 1
  • FETCH_USER Procedure Signature 2
  • FETCH_USER Procedure Signature 3
  • FIND_SECURITY_GROUP_ID Function
  • FIND_WORKSPACE Function
  • GET_ACCOUNT_LOCKED_STATUS Function
  • GET_APEX_OWNER Function
  • GET_APPLICATION_STATUS Function (Deprecated)
  • GET_ATTRIBUTE Function
  • GET_AUTHENTICATION_RESULT Function
  • GET_BLOB_FILE_SRC Function
  • GET_BUILD_OPTION_STATUS Function Signature 1 (Deprecated)
  • GET_BUILD_OPTION_STATUS Function Signature 2 (Deprecated)
  • GET_CURRENT_USER_ID Function
  • GET_DEFAULT_SCHEMA Function
  • GET_EDITION Function
  • GET_EMAIL Function
  • GET_FEEDBACK_FOLLOW_UP Function
  • GET_FILE Procedure
  • GET_FILE_ID Function
  • GET_FIRST_NAME Function
  • GET_GLOBAL_NOTIFICATION Function (Deprecated)
  • GET_GROUPS_USER_BELONGS_TO Function
  • GET_GROUP_ID Function
  • GET_GROUP_NAME Function
  • GET_HASH Function
  • GET_HIGH_CONTRAST_MODE_TOGGLE Function
  • GET_LAST_NAME Function
  • GET_NUMERIC_SESSION_STATE Function
  • GET_PREFERENCE Function
  • GET_PRINT_DOCUMENT Function Signature 1
  • GET_PRINT_DOCUMENT Function Signature 2
  • GET_PRINT_DOCUMENT Function Signature 3
  • GET_PRINT_DOCUMENT Function Signature 4
  • GET_SCREEN_READER_MODE_TOGGLE Function
  • GET_SESSION_LANG Function
  • GET_SESSION_STATE Function
  • GET_SESSION_TERRITORY Function
  • GET_SESSION_TIME_ZONE Function
  • GET_SINCE Function Signature 1
  • GET_SINCE Function Signature 2
  • GET_SUPPORTING_OBJECT_SCRIPT Function
  • GET_SUPPORTING_OBJECT_SCRIPT Procedure
  • GET_USER_ID Function
  • GET_USER_ROLES Function
  • GET_USERNAME Function
  • HOST_URL Function
  • HTML_PCT_GRAPH_MASK Function
  • INCREMENT_CALENDAR Procedure (Deprecated)
  • IR_CLEAR Procedure (Deprecated)
  • IR_DELETE_REPORT Procedure (Deprecated)
  • IR_DELETE_SUBSCRIPTION Procedure (Deprecated)
  • IR_FILTER Procedure (Deprecated)
  • IR_RESET Procedure (Deprecated)
  • IS_HIGH_CONTRAST_SESSION Function
  • IS_HIGH_CONTRAST_SESSION_YN Function
  • IS_LOGIN_PASSWORD_VALID Function
  • IS_SCREEN_READER_SESSION Function
  • IS_SCREEN_READER_SESSION_YN Function
  • IS_USERNAME_UNIQUE Function
  • KEYVAL_NUM Function
  • KEYVAL_VC2 Function
  • LOCK_ACCOUNT Procedure
  • PASSWORD_FIRST_USE_OCCURRED Function
  • PREPARE_URL Function
  • PRN Procedure
  • PUBLIC_CHECK_AUTHORIZATION Function (Deprecated)
  • PURGE_REGIONS_BY_APP Procedure
  • PURGE_REGIONS_BY_NAME Procedure
  • PURGE_REGIONS_BY_PAGE Procedure
  • REDIRECT_URL Procedure
  • REMOVE_PREFERENCE Procedure
  • REMOVE_SORT_PREFERENCES Procedure
  • REMOVE_USER Procedure Signature 1
  • REMOVE_USER Procedure Signature 2
  • REPLY_TO_FEEDBACK Procedure
  • RESET_AUTHORIZATIONS Procedure (Deprecated)
  • RESET_PASSWORD Procedure
  • RESET_PW Procedure
  • SAVEKEY_NUM Function
  • SAVEKEY_VC2 Function
  • SET_APP_BUILD_STATUS Procedure (Deprecated)
  • SET_APPLICATION_STATUS Procedure (Deprecated)
  • SET_ATTRIBUTE Procedure
  • SET_AUTHENTICATION_RESULT Procedure
  • SET_BUILD_OPTION_STATUS Procedure (Deprecated)
  • SET_CURRENT_THEME_STYLE Procedure (Deprecated)
  • SET_CUSTOM_AUTH_STATUS Procedure
  • SET_EDITION Procedure
  • SET_EMAIL Procedure
  • SET_FIRST_NAME Procedure
  • SET_GLOBAL_NOTIFICATION Procedure (Deprecated)
  • SET_GROUP_GROUP_GRANTS Procedure
  • SET_GROUP_USER_GRANTS Procedure
  • SET_LAST_NAME Procedure
  • SET_PARSING_SCHEMA_FOR_REQUEST Procedure
  • SET_PREFERENCE Procedure
  • SET_SECURITY_GROUP_ID Procedure
  • SET_SESSION_HIGH_CONTRAST_OFF Procedure
  • SET_SESSION_HIGH_CONTRAST_ON Procedure
  • SET_SESSION_LANG Procedure
  • SET_SESSION_LIFETIME_SECONDS Procedure
  • SET_SESSION_MAX_IDLE_SECONDS Procedure
  • SET_SESSION_SCREEN_READER_OFF Procedure
  • SET_SESSION_SCREEN_READER_ON Procedure
  • SET_SESSION_STATE Procedure
  • SET_SESSION_TERRITORY Procedure
  • SET_SESSION_TIME_ZONE Procedure
  • SET_USERNAME Procedure
  • SET_WORKSPACE Procedure
  • SHOW_HIGH_CONTRAST_MODE_TOGGLE Procedure
  • SHOW_SCREEN_READER_MODE_TOGGLE Procedure
  • STRING_TO_TABLE Function (Deprecated)
  • STRONG_PASSWORD_CHECK Procedure
  • STRONG_PASSWORD_VALIDATION Function
  • SUBMIT_FEEDBACK Procedure
  • SUBMIT_FEEDBACK_FOLLOWUP Procedure
  • TABLE_TO_STRING Function (Deprecated)
  • UNEXPIRE_END_USER_ACCOUNT Procedure
  • UNEXPIRE_WORKSPACE_ACCOUNT Procedure
  • UNLOCK_ACCOUNT Procedure
  • URL_ENCODE Function (Deprecated)
  • WORKSPACE_ACCOUNT_DAYS_LEFT Function
• APEX_WEB_SERVICE
  • About the APEX_WEB_SERVICE API
    • Invoking a SOAP-style Web Service
    • Invoking a RESTful-style Web Service
    • Setting Cookies and HTTP Headers
    • Retrieving Cookies and HTTP Headers
  • About Web Credentials and APEX_WEB_SERVICE
  • Data Types
  • Global Variables
  • APPEND_TO_MULTIPART Procedure Signature 1
  • APPEND_TO_MULTIPART Procedure Signature 2
  • BLOB2CLOBBASE64 Function
  • CLEAR_REQUEST_COOKIES Procedure
  • CLEAR_REQUEST_HEADERS Procedure
  • CLOBBASE642BLOB Function
  • GENERATE_REQUEST_BODY Function
  • GET_REQUEST_HEADER Function
  • MAKE_REQUEST Function Signature 1
  • MAKE_REQUEST Function Signature 2
  • MAKE_REQUEST Procedure Signature 1
  • MAKE_REQUEST Procedure Signature 2
  • MAKE_REST_REQUEST Function
  • MAKE_REST_REQUEST_B Function
  • OAUTH_AUTHENTICATE Procedure Signature 1
  • OAUTH_AUTHENTICATE Procedure Signature 2 (Deprecated)
  • OAUTH_AUTHENTICATE_CREDENTIAL Procedure
  • OAUTH_GET_LAST_TOKEN Function
  • OAUTH_SET_TOKEN Procedure
  • PARSE_RESPONSE Function
  • PARSE_RESPONSE_CLOB Function
  • PARSE_XML Function
  • PARSE_XML_CLOB Function
  • REMOVE_REQUEST_HEADER Procedure
  • SET_REQUEST_ECID_CONTEXT Procedure
  • SET_REQUEST_HEADERS Procedure
• APEX_WORKFLOW
  • Constants and Data Types
  • CONTINUE_ACTIVITY Procedure Signature 1
  • CONTINUE_ACTIVITY Procedure Signature 2
  • DELETE_WORKFLOWS Procedure
  • GET_LOV_ACTIVITY_STATE Function
  • GET_LOV_WORKFLOW_STATE Function
  • GET_NEXT_PURGE_TIMESTAMP Function
  • GET_VARIABLE_CLOB_VALUE Function
  • GET_VARIABLE_VALUE Function
  • GET_WORKFLOW_STATE Function
  • GET_WORKFLOWS Function
  • IS_ADMIN Function
  • IS_ALLOWED Function
  • IS_OF_PARTICIPANT_TYPE Function
  • MIGRATE_INSTANCE Procedure
  • REFRESH_PARTICIPANTS Procedure
  • REMOVE_DEVELOPMENT_INSTANCES Procedure
  • RESUME Procedure
  • RETRY Procedure
  • SET_ACTIVITY_DUE_DATE Procedure
  • SET_LOG_LEVEL Procedure
  • START_WORKFLOW Function
  • SUSPEND Procedure
  • TERMINATE Procedure
  • TERMINATE_FAULTED_WORKFLOWS Procedure
  • UPDATE_VARIABLES Procedure
• APEX_ZIP
  • Data Types
  • ADD_FILE Procedure
  • FINISH Procedure
  • GET_DIR_ENTRIES Function
  • GET_FILE_CONTENT Function Signature 1 (Deprecated)
  • GET_FILE_CONTENT Function Signature 2
  • GET_FILES Function (Deprecated)
• JavaScript APIs