I don't know how that other database works but you use bulk collections to do bulk inserts updates or deletes. Here is a doc reference on Tahiti: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls. htm ----------------------- Ric Van Dyke Hotsos Enterprises Cell 248-705-0624 ----------------------- Hotsos Symposium 2009 dedicated to performance and nothing but performance March 8 - 12, 2009 in Dallas, Texas Be there. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Monday, May 05, 2008 10:46 AM To: oracle-l@xxxxxxxxxxxxx Subject: [Q] ORACLE support bilk insert like SQL server?? Does any version of ORACLE support "bulk insert" like SQL server? I search on Google and can NOT find any info. Thanks. ________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. <http://us.rd.yahoo.com/evt=51733/*http:/mobile.yahoo.com/;_ylt=Ahu06i62 sR8HDtDypao8Wcj9tAcJ%20>