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
Dive into APEX Bloghttps://diveintoapex.com
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/
Builder + App Side-by-Side in Chrome

In the latest Google Chrome release (143.0.7499.41) a new Split View feature is handy for Oracle APEX developers. It lets you run APEX Builder and your runtime app side-by-side in the same tab. Her…

Dive Into APEX
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/
Server-Side Geocoding & AI-Driven Point of Interest Lookup #joelkallmanday

In APEX on Autonomous Database, use declarative, server-side geocoding to find coordinates for an address. Then you can see it on a map, measure its distance from another point, find it within a ra…

Dive Into APEX
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/
Sanitizing HTML Server-Side

A colleague asked how he might sanitize client-submitted HTML to remove potential Cross-Site Scripting vulnerabilities. His use case was an ORDS REST service accepting HTML content, so he wanted to…

Dive Into APEX
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/
Including User Input in AI Prompt

Sometimes it can be useful to include end-user input in a generative AI system prompt. You can do this with both the Generate Text with AI dynamic action, as well as the Show AI Assistant one. We&#…

Dive Into APEX
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/
Dynamic Behavior Buffet #JoelKallmanDay

To commemorate Joel Kallman Day, I dive into four interesting APEX ideas related to dynamic behavior that my dev team colleagues John Snyders and Stefan Dobre taught me recently. We’ll explor…

Dive Into APEX

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/

Oracle APEX 24.1 Product Tour

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…

Dive Into APEX
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/
Intersection Rows as Multivalue Item

End-users find multivalue page items intuitive for quick data entry, and APEX devs have many kinds to choose from. However, using multivalue items in the simplest way means storing data in a single…

Dive Into APEX
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/
Flexing Fusion Apps Filters

I enjoyed returning to the APEX Alpe Adria conference to chat with and learn from members of the APEX community. If you joined me in Maribor, thanks for your interest in extending Fusion Applicatio…

Dive Into APEX
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/
Simplify APEX App REST APIs with JSON Duality Views

When writing your APEX apps, it’s best to put business logic in packages. This practice eases maintenance, improves performance, and favors reuse. I set out to combine an Oracle 23c JSON Rela…

Dive Into APEX
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
Support for Fusion Apps Extensions in Oracle APEX 23.2

YouTube