oracle的XMLTABLE语法

1.SELECT *
  FROM XMLTABLE('Page/Data' PASSING
                XMLTYPE('<Page><Data Period="1" AKEY="671_1" SEQ="1" FVL="内容12" /></Page>')
                COLUMNS SEQ NUMBER PATH '@Period',
                ASSET_TYPE CHAR(20) PATH '@AKEY',
                FIELD_SEQ NUMBER PATH '@SEQ',
                FIELD_VALUE VARCHAR2(300) PATH '@FVL') A
 WHERE A.SEQ = 1
 ORDER BY A.SEQ, A.FIELD_SEQ;

 

Page/Data      解析层级

@Period        解析字段

 

XMLTABLE(解析的层级 passing xmltype('被解析的字符串')) COLUMNS 名称以及定义+解析字段）

 

2.  SELECT EXTRACTVALUE(VALUE(T), '/selection')
    FROM TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE('<data><selection>1</selection><selection>2</selection></data>'),
                                   '/data/selection'))) T;