I have following XML in /tmp/dta.xml *stfm file:
I need to know for each node belong pair a and b.
I prepare somethig like this:
I receive
1 a1 b1
2 a2 b2
3 a1 b1
4 a2 b2
5 a3 b3
but I need also "node" number. It means
node
1 1 a1 b1
1 2 a2 b2
2 3 a1 b1
2 4 a2 b2
2 5 a3 b3
Element <node> can have the same value.
Do you have any idea?
Code:
<group> <node>A</node> <data> <a>a1</a> <b>b1</b> </data> <data> <a>a2</a> <b>b2</b> </data> </group> <group> <node>A</node> <data> <a>a1</a> <b>b1</b> </data> <data> <a>a2</a> <b>b2</b> </data> <data> <a>a3</a> <b>b3</b> </data> </group>
I prepare somethig like this:
Code:
select xmldta.* from xmltable ('/group' passing xmlparse (document get_xml_file('/tmp/dta.txt') columns seq for ordinarlity, a char(5) path 'data/a', b char(5) path 'data/b' )
1 a1 b1
2 a2 b2
3 a1 b1
4 a2 b2
5 a3 b3
but I need also "node" number. It means
node
1 1 a1 b1
1 2 a2 b2
2 3 a1 b1
2 4 a2 b2
2 5 a3 b3
Element <node> can have the same value.
Do you have any idea?
Comment