Hi Team
I have a requirement wherein i need to pull out few information from an xml file loacated on a remote Machine. I preferred to load the XML file
into Oracle Table (xmltype) column and then query the XML file from that table. Though the select from my table is too slow only for 5 rows.
Format of Output Data Display: A typical hierarchy can have upto 5 substances, so we can have
medicinalproduct Activesubstance1 Activesubstance2 Activesubstance3 Activesubstance4 Activesubstance5
Drug1 Substance1 Substance2 NUll NUll NUll
Sample Data:
<drug>
<drugcharacterization>1</drugcharacterization> ----------------------------------**
<medicinalproduct>Drug1</medicinalproduct> ---------------------------------**
<obtaindrugcountry></obtaindrugcountry>
<drugbatchnumb>123</drugbatchnumb>
<drugauthorizationnumb>123</drugauthorizationnumb>
<drugauthorizationcountry></drugauthorizationcountry>
<drugauthorizationholder>Spare MAH</drugauthorizationholder>
<drugstructuredosagenumb></drugstructuredosagenumb>
<drugstructuredosageunit></drugstructuredosageunit>
<drugseparatedosagenumb></drugseparatedosagenumb>
<drugintervaldosageunitnumb></drugintervaldosageunitnumb>
<drugintervaldosagedefinition></drugintervaldosagedefinition>
<drugdosagetext></drugdosagetext>
<drugdosageform></drugdosageform>
<actiondrug></actiondrug>
<drugrecurreadministration></drugrecurreadministration>
<drugadditional></drugadditional>
<activesubstance>
<activesubstancename>Substance1</activesubstancename> ---------------------------------**
</activesubstance>
<activesubstance>
<activesubstancename>Substance2</activesubstancename> ---------------------------------**
</activesubstance>
<drugreactionrelatedness>
<drugreactionassesmeddraversion>18.1</drugreactionassesmeddraversion>
<drugreactionasses>10007515</drugreactionasses>
<drugassessmentsource>2</drugassessmentsource>
<drugassessmentmethod>EVCTM</drugassessmentmethod>
<drugresult>1</drugresult>
</drugreactionrelatedness>
</drug>
<drug>
<drugcharacterization>2</drugcharacterization>
<medicinalproduct>Drug2</medicinalproduct>
<obtaindrugcountry></obtaindrugcountry>
<drugbatchnumb>123</drugbatchnumb>
<drugauthorizationnumb>123</drugauthorizationnumb>
<drugauthorizationcountry></drugauthorizationcountry>
<drugauthorizationholder>Spare MAH</drugauthorizationholder>
<drugstructuredosagenumb></drugstructuredosagenumb>
<drugstructuredosageunit></drugstructuredosageunit>
<drugseparatedosagenumb></drugseparatedosagenumb>
<drugintervaldosageunitnumb></drugintervaldosageunitnumb>
<drugintervaldosagedefinition></drugintervaldosagedefinition>
<drugdosagetext></drugdosagetext>
<drugdosageform></drugdosageform>
<actiondrug></actiondrug>
<drugrecurreadministration></drugrecurreadministration>
<drugadditional></drugadditional>
<activesubstance>
<activesubstancename>Substance3</activesubstancename>
</activesubstance>
<activesubstance>
<activesubstancename>Substance4/activesubstancename>
</activesubstance>
<drugreactionrelatedness>
<drugreactionassesmeddraversion>18.1</drugreactionassesmeddraversion>
<drugreactionasses>10007515</drugreactionasses>
<drugassessmentsource>2</drugassessmentsource>
<drugassessmentmethod>EVCTM</drugassessmentmethod>
<drugresult>1</drugresult>
</drugreactionrelatedness>
</drug>