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;