Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,629 of 2,288    |
|    Brian Marasca to All    |
|    Insert multiple rows via XML?    |
|    07 Aug 04 14:51:58    |
      From: bmarasca@optonline.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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca