XML Parsing In Oracle [message #435769] |
Thu, 17 December 2009 19:03 |
shashish
Messages: 2 Registered: October 2008
|
Junior Member |
|
|
Hi ,
I need to parse the below xml and load it into a set of tables , this is very critical , can someone respond and help me ASAP
<?xml version="1.0" encoding="utf-8"?>
<!-- Created with Liquid XML Studio 1.0.8.0 -->
<tns:partnerCatalogConfig xmlns xmlns:xsixsi:schemaLocation
<tns:profile>
<tns:partner_name>string</tns:partner_name>
<tns:data_rendering_type_code>string</tns:data_rendering_type_code>
<tns:channel_code>string</tns:channel_code>
<tns:subscription_type_code>string</tns:subscription_type_code>
<tns:delivery_mode_type_code>string</tns:delivery_mode_type_code>
<tns:business_contact_name>string</tns:business_contact_name>
<tns:business_contact_email>string</tns:business_contact_email>
<tns:business_contact_phone>string</tns:business_contact_phone>
<tns:business_contact_phone_ext>string</tns:business_contact_phone_ext>
<tns:technical_contact_name>string</tns:technical_contact_name>
<tns:technical_contact_email>string</tns:technical_contact_email>
<tns:technical_contact_phone>string</tns:technical_contact_phone>
<tns:technical_contact_phone_ext>string</tns:technical_contact_phone_ext>
<tns:business_address_line1>string</tns:business_address_line1>
<tns:business_address_line2>string</tns:business_address_line2>
<tns:business_address_city>string</tns:business_address_city>
<tns:business_address_state>string</tns:business_address_state>
<tns:business_address_zip>string</tns:business_address_zip>
<tns:partner_url>string</tns:partner_url>
<tns:creation_date>2016-02-10</tns:creation_date>
<tns:created_by>string</tns:created_by>
<tns:last_update_date>1974-10-20</tns:last_update_date>
<tns:last_updated_by>string</tns:last_updated_by>
<tns:last_catalog_generated>1977-10-09</tns:last_catalog_generated>
<tns:trusted>string</tns:trusted>
<tns:bill_summary_required>string</tns:bill_summary_required>
<tns:grace_period>300</tns:grace_period>
<tns:start_date>1996-01-25</tns:start_date>
<tns:end_date>2008-01-21</tns:end_date>
</tns:profile>
<tns:markets>
<tns:market>
<tns:code>string</tns:code>
<tns:start_date>2017-03-27</tns:start_date>
<tns:end_date>1988-04-23</tns:end_date>
</tns:market>
</tns:markets>
<tns:accountTypeSubTypes>
<tns:accountTypeSubtype>
<tns:code>string</tns:code>
<tns:start_date>1980-07-20</tns:start_date>
<tns:end_date>1980-06-28</tns:end_date>
</tns:accountTypeSubtype>
<tns:accountTypeSubtype>
<tns:code>string</tns:code>
<tns:start_date>2011-10-17</tns:start_date>
<tns:end_date>1992-02-15</tns:end_date>
</tns:accountTypeSubtype>
<tns:accountTypeSubtype>
<tns:code>string</tns:code>
<tns:start_date>1984-09-03</tns:start_date>
<tns:end_date>2004-03-01</tns:end_date>
</tns:accountTypeSubtype>
</tns:accountTypeSubTypes>
<tns:planTypeClassifications>
<tns:planTypeClassification>
<tns:code>string</tns:code>
<tns:start_date>1983-04-20</tns:start_date>
<tns:end_date>2019-07-22</tns:end_date>
</tns:planTypeClassification>
<tns:planTypeClassification>
<tns:code>string</tns:code>
<tns:start_date>2016-04-20</tns:start_date>
<tns:end_date>1972-03-06</tns:end_date>
</tns:planTypeClassification>
<tns:planTypeClassification>
<tns:code>string</tns:code>
<tns:start_date>2011-02-11</tns:start_date>
<tns:end_date>2015-08-27</tns:end_date>
</tns:planTypeClassification>
<tns:planTypeClassification>
<tns:code>string</tns:code>
<tns:start_date>1980-07-13</tns:start_date>
<tns:end_date>1972-10-10</tns:end_date>
</tns:planTypeClassification>
</tns:planTypeClassifications>
<tns:contractTerms>
<tns:contractTerm>
<tns:code>string</tns:code>
<tns:start_date>2000-04-27</tns:start_date>
<tns:end_date>2005-03-10</tns:end_date>
</tns:contractTerm>
<tns:contractTerm>
<tns:code>string</tns:code>
<tns:start_date>2006-10-28</tns:start_date>
<tns:end_date>2007-09-10</tns:end_date>
</tns:contractTerm>
<tns:contractTerm>
<tns:code>string</tns:code>
<tns:start_date>1990-07-16</tns:start_date>
<tns:end_date>2004-06-02</tns:end_date>
</tns:contractTerm>
<tns:contractTerm>
<tns:code>string</tns:code>
<tns:start_date>1971-11-15</tns:start_date>
<tns:end_date>1975-02-21</tns:end_date>
</tns:contractTerm>
<tns:contractTerm>
<tns:code>string</tns:code>
<tns:start_date>2010-06-11</tns:start_date>
<tns:end_date>2005-12-15</tns:end_date>
</tns:contractTerm>
</tns:contractTerms>
<tns:serviceIndicators>
<tns:serviceIndicator>
<tns:code>string</tns:code>
<tns:start_date>2005-04-09</tns:start_date>
<tns:end_date>1979-04-20</tns:end_date>
</tns:serviceIndicator>
<tns:serviceIndicator>
<tns:code>string</tns:code>
<tns:start_date>2002-03-07</tns:start_date>
<tns:end_date>2002-10-10</tns:end_date>
</tns:serviceIndicator>
</tns:serviceIndicators>
<tns:rateplans>
<tns:selectionType>string</tns:selectionType>
<tns:rateplan>
<tns:code>string</tns:code>
<tns:start_date>1999-10-28</tns:start_date>
<tns:end_date>1980-04-06</tns:end_date>
</tns:rateplan>
</tns:rateplans>
<tns:services>
<tns:selectionType>string</tns:selectionType>
<tns:service>
<tns:code>string</tns:code>
<tns:start_date>2012-05-21</tns:start_date>
<tns:end_date>2004-10-04</tns:end_date>
</tns:service>
<tns:service>
<tns:code>string</tns:code>
<tns:start_date>1981-11-07</tns:start_date>
<tns:end_date>1984-05-18</tns:end_date>
</tns:service>
<tns:service>
<tns:code>string</tns:code>
<tns:start_date>1990-05-28</tns:start_date>
<tns:end_date>1980-12-07</tns:end_date>
</tns:service>
</tns:services>
<tns:devices>
<tns:device>
<tns:code>string</tns:code>
<tns:start_date>1974-09-09</tns:start_date>
<tns:end_date>1988-07-09</tns:end_date>
</tns:device>
<tns:device>
<tns:code>string</tns:code>
<tns:start_date>1992-12-20</tns:start_date>
<tns:end_date>2012-12-17</tns:end_date>
</tns:device>
<tns:device>
<tns:code>string</tns:code>
<tns:start_date>2013-03-15</tns:start_date>
<tns:end_date>2002-06-15</tns:end_date>
</tns:device>
<tns:device>
<tns:code>string</tns:code>
<tns:start_date>2018-09-25</tns:start_date>
<tns:end_date>1983-04-14</tns:end_date>
</tns:device>
</tns:devices>
</tns:partnerCatalogConfig>
Note : The different types here should go to different tables in oracle .
ALL THE CODE SHOULD BE WRITTEN IN ORACLE
[Updated on: Thu, 17 December 2009 19:19] Report message to a moderator
|
|
|
|
|
|