Re: XML Parsing Question

with your_xml as
(select xmltype('<?xml version="1.0" encoding="ISO-8859-1" ?>
<ETF_Report>
<ReportFile>etf_research_mcg.pdf</ReportFile>
<Title>ETF_RESEARCH</Title>
<ReportType>3</ReportType>
<ReportTypeDescription>Style Box ETF Report</ReportTypeDescription>
<Tickers>
<Ticker>IWP</Ticker>
<Ticker>IVOG</Ticker>
<Ticker>MDYG</Ticker>
<Ticker>RFG</Ticker>
<Ticker>FNY</Ticker>
<Ticker>IJK</Ticker>
<Ticker>PXMG</Ticker>
<Ticker>VOT</Ticker>
<Ticker>JKH</Ticker>
<Ticker>FVL</Ticker>
</Tickers>
</ETF_Report>') xml

from dual)
select extractvalue(value(x), '/Ticker') ticker from xmltable('/*/Tickers/Ticker'

       passing (select xml  
                from   your_xml)) x;