Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Inserting multiple rows with one insert sql = ?
No, you have to do it row by row or use a loader program
like SQLLoader to load in from a flat file.
Mark Fisher
Technical Specialist
Britannic Assurance
Steve Chapman wrote in message <01bdee20$f8a4dc80$e89a3398_at_us0071465>...
>can you do this:
>
> insert into table values (
> 1, 'stuff', 'stuff',
> 2, 'stuff', 'stuff',
> 3, 'stuff', 'stuff');
Received on Mon Oct 05 1998 - 04:23:27 CDT