Inserting multiple rows with one insert sql = ?

hi all,

can anybody tell me if this is valid syntax, in Oracle 7 or Oracle 8 or anywhere else (SQL-92, SQL Server, Sybase, etc.):

given table:

   col1 number,
   col2 char,
   col3 char

can you do this:

   insert into table values (

      1, 'stuff', 'stuff',
      2, 'stuff', 'stuff',
      3, 'stuff', 'stuff');

i thought insert was limited to just ONE row.

yes, i know that multiple rows can be inserted like so:

   insert into table
   select * from some_other_table;

thanks!

--
Steve Chapman
Glaxo Wellcome Received on Fri Oct 02 1998 - 11:32:34 CDT