Oracle XML 쿼리
출처 : http://www.oracleclub.com/article/55741 설명은 안 하겠습니다. WITH t AS ( SELECT XMLTYPE(' Type1 REQ1 Type2 REQ3 Type3 REQ4 ') v FROM dual ) SELECT ExtractValue(Value(p), '/META/META-VALUE') "META-VALUE" FROM t , TABLE(XMLSequence(Extract(v, '/ROOT/META[@use="report"]'))) p WHERE ExtractValue(Value(p), '/META/META-NAME') = 'Type1' ; Tistory 태그: oracle,sql,query,xml,xmltype,오라클,쿼리