How to Build APEX Plug-ins in PL/SQL Using APEX_PLUGIN and APEX_PLUGIN_UTIL
A tested guide to APEX_PLUGIN and APEX_PLUGIN_UTIL in Oracle APEX 26.1, from render callbacks and Ajax to data, substitutions, and REST sources.
AI-Assisted
Posts tagged AI-Assisted are created with support from artificial intelligence. I use AI tools to research, draft, and refine ideas—combining human insight with machine precision to deliver clear, informed, and creative content.
How to Call Generative AI and Search from PL/SQL Using APEX_AI and APEX_SEARCH
A tested guide to APEX_AI, APEX_SEARCH, APEX_SPATIAL, and APEX_PWA in Oracle APEX 26.1, from prompts and chats to search, maps, and push.
How to Create Tasks and Run Workflows from PL/SQL Using APEX_HUMAN_TASK and APEX_WORKFLOW
A tested guide to APEX_HUMAN_TASK, APEX_WORKFLOW, APEX_AUTOMATION, and APEX_BACKGROUND_PROCESS, from approval tasks to workflows and schedules.
How to Filter and Reset Interactive Reports and Grids from PL/SQL Using APEX_IR and APEX_IG
A tested guide to APEX_IR and APEX_IG in Oracle APEX, from adding filters in page processes to resetting, cloning, and reassigning saved reports.
How to Handle Errors, Debug, and Translate Messages Using APEX_ERROR and APEX_DEBUG
A tested guide to APEX_ERROR, APEX_DEBUG, and APEX_LANG in Oracle APEX, from inline errors and error handling to debug logs and translations.
How to Send Emails, Print Documents, and Create Barcodes Using APEX_MAIL and APEX_BARCODE
A tested guide to APEX_MAIL, APEX_PRINT, and APEX_BARCODE in Oracle APEX, from queued emails and templates to documents, QR codes, and barcodes.
How to Manage Sign-In, Roles, and Authorization from PL/SQL in Oracle APEX
A tested guide to APEX_AUTHENTICATION, APEX_AUTHORIZATION, APEX_ACL, APEX_CUSTOM_AUTH, and APEX_LDAP, from login to roles and directories.
How to Call REST APIs from PL/SQL Using APEX_WEB_SERVICE
A tested guide to APEX_WEB_SERVICE, APEX_CREDENTIAL, APEX_JWT, and APEX_HTTP, from REST calls and uploads to credentials and JSON Web Tokens.
How to Export Data to PDF and Excel and Load Files Using APEX_DATA_EXPORT
A tested guide to APEX_DATA_EXPORT, APEX_DATA_LOADING, and APEX_REST_SOURCE_SYNC, from exporting and downloading files to loading and syncing data.
How to Query Local and REST Data Sources from PL/SQL Using APEX_EXEC
A tested guide to APEX_EXEC in Oracle APEX, from query contexts, filters, and REST Data Sources to DML contexts and lost-update detection.
How to Store Temporary Data in an APEX Session Using APEX_COLLECTION
A tested guide to APEX_COLLECTION in Oracle APEX, from creating collections from queries to merging members and detecting what users changed.
How to Parse CSV, Excel, and ZIP Files in PL/SQL Using APEX_DATA_PARSER and APEX_ZIP
A tested guide to APEX_DATA_PARSER and APEX_ZIP in Oracle APEX, from parsing uploaded files and reading their profiles to building ZIP archives.
How to Parse and Generate JSON in PL/SQL Using APEX_JSON
A tested guide to APEX_JSON in Oracle APEX, from parsing and reading values by path to writing objects, cursors, and Ajax callback responses.
How to Escape Output and Render Markdown Using APEX_ESCAPE and APEX_MARKDOWN
A tested guide to APEX_ESCAPE, APEX_MARKDOWN, APEX_JAVASCRIPT, APEX_CSS, and APEX_T_JAVASCRIPT_OBJECT, with every escaping function and its output.
How to Split, Join, and Format Strings Using APEX_STRING in Oracle APEX
A tested guide to APEX_STRING and APEX_STRING_UTIL in Oracle APEX, from splitting and joining lists to finding emails, links, and identifiers in text.
How to Manage Users, Preferences, and Caches Using APEX_UTIL
A tested guide to APEX_UTIL in Oracle APEX, from session state, caches, and preferences to user accounts, passwords, hashes, and feedback.
How to Read Application, Page, and Region Details in PL/SQL Using APEX_APPLICATION and APEX_PAGE
A tested guide to APEX_APPLICATION, APEX_PAGE, APEX_REGION, APEX_APP_SETTING, and APEX_THEME, the PL/SQL packages for application context.
How to Create APEX Sessions and Manage Session State from PL/SQL
A tested guide to APEX_SESSION and APEX_SESSION_STATE in Oracle APEX, from sessions in jobs and scripts to typed item values and their traps.