APEX from the Field

APEX, PL/SQL and SQL

  • Hi, I’m Denio 👋
  • Certifications
  • Refreshing Multiple Oracle APEX Regions with a Single Dynamic Action Using jQuery Selectors
    APEX

    Refreshing Multiple Oracle APEX Regions with a Single Dynamic Action Using jQuery Selectors

    In this video, I demonstrate a practical Oracle APEX dashboard pattern that uses a single Dynamic Action combined with a jQuery selector to refresh multiple regions at once. The demonstration starts with a simple page containing filters and one report region refreshed by a button. As the page evolves into a real dashboard with multiple

    Read article

    02/10/2026
    denioflavio
  • Updating XML Stored as CLOB in Oracle Using XMLQuery
    SQL

    Updating XML Stored as CLOB in Oracle Using XMLQuery

    Using a simplified shopping cart XML example, the content shows how to safely modify an XML element while properly handling namespaces and following the required copy / modify / return pattern defined by the XQuery standard. The example intentionally reflects real-world constraints, where the XML is already stored as CLOB and changing the data model…

    Read article

    01/31/2026
    denioflavio
←Newer posts

Categories

  • APEX (7)
  • ORDS (3)
  • PL/SQL (7)
  • SQL (3)

Recent Posts

  • When one login method is not enough04/27/2026
  • From Social Login to API Access: Building a Self-Service OAuth Client Flow with APEX and ORDS04/19/2026
  • When the Schema Does Not Speak Business: Testing Oracle 26ai Annotations for NL2SQL04/12/2026
  • Assertions in Oracle: one of those features that immediately made me think about old scars04/05/2026
  • Beyond Hidden Items: Passing State Across APEX Page Processes03/15/2026

Tags

Ajax Callback annotations API authentication scheme Collections debug Dynamic Action jQuery n2sql oauth ords plsql Process Social Sign-In sql type xml

Copyright © APEX From the Field. Practical Oracle APEX, PL/SQL, SQL, ORDS, REST APIs, and AI from real projects.

  • GitHub
  • LinkedIn
  • Youtube