Добрый день.

При парсинге xml-файла

<teg>
<teg1 tegType="1234">
<Title Cat="13">OMG</Title>
</teg1>
<teg1 tegType="5678">
<Title SinceDay="06" SinceMonth="Jun" SinceYear="2015" ToDay="16" ToMonth="Mar" ToYear="2017" OccCat="13">abcd</Title>
<Title SinceMonth="Nov" SinceYear="2005" ToYear="2010" OccCat="3">efg</Title>
<Title SinceYear="2009" OccCat="3">higk</OccTitle>
<Title SinceDay="04" SinceMonth="Feb" SinceYear="2004" ToYear="2005" OccCat="2">lmnop</Title>
</teg1>
</teg>

Как вывести значение тэга Title - abcd, efg, higk, lmnop ?

for i in (
select
Tbl.tegType "tegType",
Tbl.TitleXml "TitleXml"
from
XMLTABLE
(
'//teg1' PASSING rec."DataXML"
COLUMNS
tegType varchar2(250) path '@tegType',
TitleXml XMLType path '//Title'
) Tbl
)
loop
blablabla
end loop;

Вопрос снят.
Решение нашла.