如何在数据库中操作XML

Question

select ... from ...
where contains(text,'2 WITHIN Module@ID')

Answer 1

给个例子给你
SELECT
EXTRACTVALUE(VALUE(T),'DOMASTER/DONO') DONO,
TO_DATE(EXTRACTVALUE(VALUE(T),'DOMASTER/RECEIVEDATE'),'YYYY-MM-DD HH24:MI:SS') RECEIVEDATE,
TO_DATE(EXTRACTVALUE(VALUE(T),'DOMASTER/LOADDATE'),'YYYY-MM-DD HH24:MI:SS') LOADDATE
FROM TABLE(XMLSEQUENCE(EXTRACT(sourcexml,'/ROOT/DO/DOMASTER'))) T
WHERE EXTRACTVALUE(VALUE(T),'DOMASTER/SYSTEMTAG')=SYSTEM_TAG;