Re: XML Parsing Question

From: ExecMan <artmerar_at_yahoo.com>
Date: Tue, 1 May 2012 06:37:18 -0700 (PDT)
Message-ID: <6c397e93-d3a6-4027-be05-cdecfdbf7973_at_t16g2000yqt.googlegroups.com>

On May 1, 4:24 am, dombrooks <dombro..._at_hotmail.com> wrote:
> Use SQL.
>
> 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;

Will this work is "your_xml" is read from a file? I am parsing XML files. Received on Tue May 01 2012 - 08:37:18 CDT