Re: How can I insert multiple values in the same SQL command?

Hello neil,

send a pl/sql block like this:

begin
 insert ......;
 insert ......;
.....
end;

HTH
Philippe

Neil Robinson wrote in message <7f4bhd$upf$1_at_news6.svr.pol.co.uk>...
>I need to insert as many as 10 records in one sql command. I've tried
>guessing at the correct syntax, but cannot do it. I'll be inserting data
>from variables rather than from another table, so I can't use the "INSERT
>([fields]) VALUES (SELECT * FROM....) syntax either.
>
>Any help would be greatly appreciated.
>
>--
>Neil Robinson
>
>
Received on Thu Apr 15 1999 - 08:06:28 CDT