Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert multiple rows with a single statement
sybrandb_at_hccnet.nl wrote:
>> I have 200 such rows. Instead of running the insert command 200 times, >> is there a way of running it once and pass to it all data values? >> Thanks, >> Sashi
No, he's probably just asking if Oracle supports Standard SQL "table value constructors":
insert into onsite_support_costs
(SITE_ID, LB_CODE, ONSITE_SUPPORT_COST)
values
('Site12284','HZ10',1944.96), ('Site14041','JH96',1728.85), ('Site14942','JV98',28208.94),
Obviously it's not supported :-)
Dieter Received on Sat Aug 11 2007 - 03:13:38 CDT