Re: Create schema & load data via XML files

Hi,

> My challenge to figure how to create the tables & actually load the
> data into the tables.

ist the XDB installed?
http://www.oracle.com/pls/db102/to_toc?pathname=appdev.102%2Fb14259%2Ftoc.htm&remark=portal+%28Books%29

I'd prefer XDB to start with as there are lot of things out of the box.
1) to load the XML file in the DB is as simple as to put it via ftp
2) to see the XML relational use a view
http://www.oracle.com/pls/db102/to_URL?remark=ranked&urlname=http:%2F%2Fdownload.oracle.com%2Fdocs%2Fcd%2FB19306_01%2Fappdev.102%2Fb14259%2Fxdb03usg.htm%23sthref351
http://www.oracle.com/pls/db102/to_URL?remark=ranked&urlname=http:%2F%2Fdownload.oracle.com%2Fdocs%2Fcd%2FB19306_01%2Fappdev.102%2Fb14259%2Fxdb03usg.htm%23sthref415

regards,

Jaromir
> http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l


Other related posts: