Re: bulk insert using xsql (newbie)
From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Thu, 14 Aug 2003 15:41:18 -0700
Message-ID: <3F3C100E.F0C85C10_at_exxesolutions.com>
Date: Thu, 14 Aug 2003 15:41:18 -0700
Message-ID: <3F3C100E.F0C85C10_at_exxesolutions.com>
Von Shean wrote:
> I am new to xsql.
> I am been told by someone that we can bulk insert xml data using xsql. We
> give xsql an xml file which is valiadted somehow and i get a list of queries
> which i use somehow to bulk insret.
>
> Can anyone validate the sentence I mentioned above. Or can anyone tell me
> how can i bulk insert data in an xml file.
>
> Reagards,
You don'/can't bulk insert into an XML file. You can store XML in Oracle in two different fashions. One as a CLOB (fully intact document) the other shredded into a nested table.
What is it you want to do ... and with what version and edition of Oracle?
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Aug 15 2003 - 00:41:18 CEST