Re: Optimize Insert

Sascha Bahl wrote:

> Hello!
>
> How can i optimize inserts into table? Under MySQL i can use value lists
> to collect many of records. How can i insert many of record in one
> insert statement?
>
> Thanks
>
> Sascha Bahl

BEGIN
   INSERT
   INSERT
   ...
   COMMIT;
END;
/

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---