Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

From xml to table mapping question

17126Nov 4 2005 — edited Nov 7 2005

All,

Assume a XML table with entries (rows) like the one below

<root>
	<l1-2>
		<l2-3>1</l2-3>
		<l2-4>one</l2-4>
		<l2-3>11</l2-3>
		<l2-4>one one</l2-4>
		<l2-3>222</l2-3>
		<l2-4>two two two</l2-4>
	</l1-2>
</root>

What is the best approach to create a result set as listed low from this (through some combination of table,xmlsequence,extract or something else)

col1                   col2

<l2-3>1</l2-3>       <l2-4>one</l2-4>
<l2-3>11</l2-3>      <l2-4>one one</l2-4>
<l2-3>222</l2-3>     <l2-4>two two two</l2-4>

Thanks,

Peter

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2005

Added on Nov 4 2005

#performance-availability, #xml-db

3 comments

433 views