Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/pmd/pmd/issues/1510 below:

[plsql] Support XMLTABLE functions · Issue #1510 · pmd/pmd · GitHub

Oracle allows to execute SQL like queries against a XML document using XMLTABLE and other related functions:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/XMLTABLE.html#GUID-C4A32C58-33E5-4CF1-A1FE-039550D3ECFA

Code Sample demonstrating the issue:

SELECT warehouse_name warehouse,
   warehouse2."Water", warehouse2."Rail"
   FROM warehouses,
   XMLTABLE('/Warehouse'
      PASSING warehouses.warehouse_spec
      COLUMNS 
         "Water" varchar2(6) PATH 'WaterAccess',
         "Rail" varchar2(6) PATH 'RailAccess') 
      warehouse2;

Running PMD through: [CLI | Ant | Maven | Gradle | Designer | Other]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4