Skip to content
APEX from the Field
  • Home
  • About Me
  • Certifications
  • ACE Profile
  • DevDF
APEX from the Field
  • Namespace-aware XMLQuery changing a quantity from two to three inside XML stored as a CLOB
    SQL

    Updating XML Stored as CLOB in Oracle Using XMLQuery

    ByDênio Flávio 01/31/202608/23/2026

    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 to XMLTYPE is not an option. The focus is on clarity, maintainability, and correct usage of supported Oracle XML features rather than deprecated functions.

    Read More Updating XML Stored as CLOB in Oracle Using XMLQueryContinue

Page navigation

Previous PagePrevious 1 2 3

Search

Categories

  • APEX (15)
  • ORDS (4)
  • PL/SQL (9)
  • SQL (3)

RECENT posts

  • The Incident Is the Prompt09/12/2026
  • Security After the Prompt: Why the APEX Runtime Changes AI-Generated Applications08/23/2026
  • The Status Badge Did Not Belong in My SQL Query08/17/2026
  • A Service Advisor Should Not Have to Send a 384-Number Vector08/10/2026
  • From customer complaint to service recommendation: automatic vector search with ORDS AutoREST08/02/2026

Tags

Agents Ajax Callback annotations API authentication scheme Collections debug Dynamic Action dynamic content feedback IA jQuery n2sql oauth ords pl/sql plsql Process Social Sign-In sql Template Directives type UI url Vector Search xml

  • Home
  • About Me
  • Certifications
  • ACE Profile
  • DevDF
Linkedin Github YouTube

© 2026 APEX from the Field

Scroll to top
  • Home
  • About Me
  • Certifications
  • ACE Profile
  • DevDF