What are the options to get xml file data in oracle database

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

tushar_spatil
Member
Posts: 12
Joined: Thu Aug 08, 2013 10:37 am

What are the options to get xml file data in oracle database

Postby tushar_spatil » Mon Aug 26, 2013 8:07 am

Hi All,

I want to know what all options oracle provides to import xml file data in oracle database relationals tables?
scenario 1) I have xmlfile placed in xyz directory
scenario 2)XMlfiel accessed directly from URL



RDBMS= 11.2.0.3
OS= HP Unix Itanium (11.31)


Thanks and Rgds
Tushar

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What are the options to get xml file data in oracle data

Postby Tim... » Tue Aug 27, 2013 6:39 am

Hi.

Manually parse it:

https://oracle-base.com/articles/9i/ ... nts-9i.php

Use XML DB to shred it automatically.

https://oracle-base.com/articles/9i/xmldb-9i.php

Just store it as an XML type, not relational data.

https://oracle-base.com/articles/9i/ ... tatype.php

The examples show loading from the file system, but the database can consume XML directly.

https://oracle-base.com/articles/9i/ ... ces-9i.php
https://oracle-base.com/articles/10g ... ws-10g.php
https://oracle-base.com/articles/mis ... nd-ssl.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

tushar_spatil
Member
Posts: 12
Joined: Thu Aug 08, 2013 10:37 am

Re: What are the options to get xml file data in oracle data

Postby tushar_spatil » Tue Aug 27, 2013 10:55 am

thanks tim

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What are the options to get xml file data in oracle data

Postby Tim... » Tue Aug 27, 2013 5:37 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 2 guests