Hi There

I received XML doc's from a customer. I'm looking for a simple way to
extract the structure so I can create a set of tables based on the
documents. Then I need to load the data from the docs into the tables.

I'm a little overwhelmed on the amount of information that's out there and
can't seem to find what I need to do this relatively simple task.

I'm PL/SQL developer as well as a background in Perl.

Any help would be GREATLY appreciated.

NavEEd wrote:
try tahiti.oracle.net and/or technet.oracle.net

Look particularly at the xml datatype (its chapt 4 n the xml database
developer's guide).

Find out about the xml data type's "Extract" method and of course, we
expect you know all about how to formulate an "XPATH" expression, right?

If not, not to worry, GOOGLE will take you to as many XPATH tutorials as
you can stand.

You also want to read the XML DB REPOSITORY stuff.


Good hunting!

NavEEd wrote:
try tahiti.oracle.com and/or technet.oracle.com

Look particularly at the xml datatype (its chapt 4 n the xml database
developer's guide).

Find out about the xml data type's "Extract" method and of course, we
expect you know all about how to formulate an "XPATH" expression, right?

If not, not to worry, GOOGLE will take you to as many XPATH tutorials as
you can stand.

You also want to read the XML DB REPOSITORY stuff.


Good hunting!