Having trouble getting output of relational view on XML data
Edit: It was the capitalization, problem solved
I am doing a POC for loading XML data for an ETL process, and I am trying to get a relational view to work, but cannot get the output. My experience with XML is very limited.
I have a table to store my XML loaded by SQL Loader
create table jbw_bix_extract_xml of xmltype xmltype store as binary xml;
My XML is formatted like this when it is loaded
<item>
<tag1>somedata
</tag1>
<tag2>somedata
</tag2>
<pzInsKey>somedata
</pzInsKey
</item>
I am testing out the relational view where I just want to get the pzinskey value, here is my view definition