Inserting multiple rows in sqlplus

Hi,

In sqlplus, I can insert a single row using:

insert into employee
(name, salary, hiredate)

values
('xyz', '86378', sysdate);

Is there a modification of the insert command that will allow me to insert more than one row into a table without having to resort to multiple "insert into ..." statements?

For example, can I insert two rows via something that lloks like:

insert into employee
(name, salary, hiredate)

values
{
 ('xyz', '86378', sysdate),
 ('abc', '84249', sysdate-1)
};

Here I am assuming that { } encloses all valid rows, with () enclosing a single row within the surrounding {}.

I do not want to use the sql loader, PL-SQL, or SQL-PLUS constructs like functions, scripts, and stored procedures.

Thanks
Raj Received on Thu Jan 22 2004 - 22:22:19 CET