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

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

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
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 Tim... » Tue Aug 27, 2013 6:39 am

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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

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
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 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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle SQL and PL/SQL Development

Who is online

Users browsing this forum: No registered users and 2 guests

cron