XML Database (MOSC)

MOSC Banner

Having trouble getting output of relational view on XML data

edited Nov 25, 2020 6:18PM in XML Database (MOSC) Question

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center