Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Nov 14 2007 - 02:26:48 CST