Work with #orclapex Builder and App side by side in the same tab in the latest Chrome. Here's how... https://diveintoapex.com/2025/12/08/builder-app-side-by-side-in-chrome/
| Dive into APEX Blog | https://diveintoapex.com |
Steve Muench
- 24 Followers
- 21 Following
- 30 Posts
Animation/Art/Theater/Math fan. Oracle APEX dev team. Hockney, Van Gogh, vintage posters. VIEW Conf volunteer. Backer: The Peasants, The Inventor, Mila, Slide
To commemorate #joelkallmanday, we pair background server-side geocoding w/ Gen AI point of interest lookup. We show addresses on a map and measure distance using a "ruler" tool. Then, Claude uses SQLcl MCP to teach us how to measure distance between points in SQL #orclapex https://diveintoapex.com/2025/10/15/server-side-geocoding-ai-driven-point-of-interest-lookup-joelkallmanday/
By combining the Oracle database's native support for Java and XSLT, this article explains a proof of concept approach using JTidy and an appropriate transformation to sanitize client-submitted HTML in the server. #orclapex https://diveintoapex.com/2025/06/21/sanitizing-html-server-side/
When generating text using an AI service or creating a chatbot, including user input can be useful. This post explains two sample apps that illustrate techniques to achieve this common requirement. #orclapex https://diveintoapex.com/2025/06/21/including-user-input-in-ai-prompt/
For #JoelKallmanDay I dive into 4 ideas colleagues taught me. We config dynamic default for cascading child list, hide/show item based on SQL lookup, show invalid fields before submit, and set grid features & refresh grid keeping selected rows. #orclapex https://diveintoapex.com/2024/10/16/dynamic-behavior-buffet-joelkallmanday/
Watch this webinar to see the broad set of Oracle APEX features you can use to quickly deliver and maintain beautiful and functional solutions that add immediate business value. Enjoy end-to-end or expand the YouTube description for a detailed topic timeline to view just a segment.
https://diveintoapex.com/2024/08/13/oracle-apex-24-1-product-tour/
End-users find multivalue page items intuitive for quick data entry + APEX devs have many to choose from. But to use them in the easiest way requires storing a delimited string. Read on to learn how to manage intersection rows using a multivalue page item. https://diveintoapex.com/2024/06/20/intersection-rows-as-multivalue-item/
I enjoyed reconnecting with APEX community members @APEXAlpeAdria for a deep dive on using #orclapex to extend Fusion Apps. This article links to my slides, explains the filtering power of FA REST APIs, and shows them in action in pages, LOVs, and PL/SQL. https://diveintoapex.com/2024/04/19/flexing-fusion-apps-filters/
While cooking up my latest recipe, the duality of JSON and relational interaction proved to be a superpower. I combine 23c JSON Duality Views w/ ORDS handlers & my app's PL/SQL package to do REST APIs that enforce the same complex logic as my Oracle APEX app #orclapex https://diveintoapex.com/2024/03/05/simplify-apex-app-rest-apis-with-json-duality-views/
APEX 23.2 brings native read/write support for Fusion Apps REST APIs (or other ADF REST-based services) using any APEX regions. After checking out the new feature video https://www.youtube.com/watch?v=Qttr796kA0s read more about it in the APEX docs https://docs.oracle.com/en/database/oracle/apex/23.2/htmdb/working-with-REST-data-sources-for-oracle-cloud-apps.html#GUID-AA383BD4-DA87-4921-B94B-B24AD84FFCF9
