Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Insert multiple rows via XML?

Insert multiple rows via XML?

From: Brian Marasca <bmarasca_at_optonline.net>
Date: Sat, 07 Aug 2004 14:51:58 GMT
Message-ID: <i06Rc.35654$zc4.11964493@news4.srv.hcvlny.cv.net>


I know that Oracle has extensive support for XML, but I can't seem to find any documentation on using an XML document to do multiple inserts into a relational table. Note, I'm *not* trying to insert an XML document into an XmlType column. I just want to construct an XML document containing the values for many rows, and then use this document to insert all of the rows with a single INSERT command. I want to do this for performance, because doing many individual INSERTs in a loop in a stored procedure yields unacceptable performance.

If anyone can help, I'd be very grateful.

Brian Received on Sat Aug 07 2004 - 09:51:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US