Caglar's Oracle Blog

Caglar's Oracle Blog

About SQL, PL/SQL and Oracle APEX

  • About Me

Category: XQuery

How to use XMLTABLE

Posted on 09/07/202410/07/2024 by Caglar

XMLTABLE is a powerful feature in Oracle databases that transforms XML data into relational format for easy querying. I would like to begin with comprehensive example. In the […]

More Details
Posted in SQL, XQueryLeave a Comment on How to use XMLTABLE

XPath / XQuery / SQL

Posted on 07/01/201909/01/2019 by Caglar

In brief, I will compare the equivalence of SQL, XQuery and XPATH. The following XML feed is used for this purpose. Oracle 11g is used. Now, I want […]

More Details
Posted in SQL, XQueryLeave a Comment on XPath / XQuery / SQL

Recent Posts

  • How to use LONG column in the WHERE clause
  • How to use XMLTABLE
  • How to implement wait spinner in APEX dynamic action
  • How to list all privileges of a user
  • How to create or alter a job

Recent Comments

  • Alexandre on How to implement wait spinner in APEX dynamic action
  • Maurits Groenenberg on How to view alert log file
  • Caglar on FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • Anjali Damani on FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • Caglar on How to implement wait spinner in APEX dynamic action

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • Uncategorized
  • XQuery

Flag Counter

© Copyright 2025, Çağlar Polat