Home » SQL & PL/SQL » SQL & PL/SQL » XML Parsing In Oracle
icon4.gif  XML Parsing In Oracle [message #435769] Thu, 17 December 2009 19:03 Go to next message
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

Re: XML Parsing In Oracle [message #435798 is a reply to message #435769] Fri, 18 December 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the create table statement for the target tables.
Post the result you should have in these tables from the data you gave.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code and use code tags.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel
Re: XML Parsing In Oracle [message #435907 is a reply to message #435769] Fri, 18 December 2009 15:54 Go to previous messageGo to next message
wakula
Messages: 150
Registered: February 2008
Location: Poland
Senior Member
I simply love posts like HLP ME PLS ASAP. Usually I simply ignore them.
Re: XML Parsing In Oracle [message #435909 is a reply to message #435769] Fri, 18 December 2009 17:30 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
Easy XML - a Programming Oriented Approach

Easy XML - Let the Database do the Work

The above links offer some information on XML and Oracle. In the end there is no ASAP solution. You need to do the necessary reading and research to understand the technology offerings in the Oracle space, then try to make it work for yourself.

That or hire someone to do the work for you, but we don't do that here.

Good luck, Kevin
Previous Topic: Using /* + Append */ insert hint
Next Topic: Select command betwen two differente owners
Goto Forum:
  


Current Time: Thu Nov 07 16:30:49 CST 2024