Discussions
Categories
- 17.9K All Categories
- 3.3K Industry Applications
- 3.3K Intelligent Advisor
- 60 Insurance
- 534.8K On-Premises Infrastructure
- 137.8K Analytics Software
- 38.6K Application Development Software
- 5.4K Cloud Platform
- 109.2K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.9K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
How to use two nested sequence-next-val functions for one XML
Hii All,
I am having a XML file which contains a multiple group of a child elements. I am inserting all these rows to a database table.
My problem is that I want to map a sequence to a database column(batch_num) which will commom for whole XML file records(this can be simlply done using sequence-next-val).Now there is another database column which has diff. sequence value for the same batch_num.
Like I want to do..
XML
<person>
<name>INDIA</name>
<hobbies>movie</hobbies>
<hobbies>music</hobbies>
</person>
table:
'batch_num' 'seq_num' 'name' 'hobbies'
1 4 INDIA movie
1 5 INDIA music
I am having a XML file which contains a multiple group of a child elements. I am inserting all these rows to a database table.
My problem is that I want to map a sequence to a database column(batch_num) which will commom for whole XML file records(this can be simlply done using sequence-next-val).Now there is another database column which has diff. sequence value for the same batch_num.
Like I want to do..
XML
<person>
<name>INDIA</name>
<hobbies>movie</hobbies>
<hobbies>music</hobbies>
</person>
table:
'batch_num' 'seq_num' 'name' 'hobbies'
1 4 INDIA movie
1 5 INDIA music
This discussion has been closed.