Beautifier with XMLTABLE

[Philippe Malera]

Actually the beautifier return this :

SELECT x.*
  FROM tmp_xmltype t,
       xmltable(xmlnamespaces(DEFAULT 'urn:iso:std:iso:20022:tech:xsd:camt.054.001.04'),
                'Document/BkToCstmrDbtCdtNtfctn/Ntfctn/Ntry' passing t.xml_data columns "REF" VARCHAR2(20) path
                'NtryRef',
                "AMOUNT" NUMBER(12, 2) path 'Amt',
                "CURR" VARCHAR2(3) path 'Amt/@Ccy',
                "VAL_DT" DATE path 'ValDt/Dt',
                "DET_REF" VARCHAR2(30) path 'NtryDtls/TxDtls/Refs/EndToEndId',
                "DET_NAME" VARCHAR2(30) path 'NtryDtls/TxDtls/RltdPties/Dbtr/Nm') x;

But this look a bit strange, it should return this :

SELECT x.*
  FROM tmp_xmltype t,
       XMLTABLE (XMLNAMESPACES (DEFAULT 'urn:iso:std:iso:20022:tech:xsd:camt.054.001.04'),
                'Document/BkToCstmrDbtCdtNtfctn/Ntfctn/Ntry'
                 PASSING t.xml_data
                 COLUMNS
                   "REF"      VARCHAR2(20)  PATH 'NtryRef',
                   "AMOUNT"   NUMBER(12, 2) PATH 'Amt',
                   "CURR"     VARCHAR2(3)   PATH 'Amt/@Ccy',
                   "VAL_DT"   DATE          PATH 'ValDt/Dt',
                   "DET_REF"  VARCHAR2(30)  PATH 'NtryDtls/TxDtls/Refs/EndToEndId',
                   "DET_NAME" VARCHAR2(30)  PATH 'NtryDtls/TxDtls/RltdPties/Dbtr/Nm'
                ) x;

 

[Marco Kalter]

I have added this to the list of enhancement requests.