Is there a way to insert multiple rows into a table in SQL without inserting one at a time like so:

INSERT INTO emp
VALUES(7698, 'Blake', 'Manager', 7839, '01-MAY-81', 2850, 30);

I want to insert multiple rows without having to re-type this row over and over again.


Thanks!

nvillare

__________________
Thanks!

N

Not unless you can formaulate the data to be inserted as a select statement:
You may have to do two stages, put the data into a temporary table first then insert from that table afterwards.



--

Joe

hi there .....
you have to use this symbol & if u want to insert more than one record into your table , the idea is so easy .. just use the sign before the column aheader name ... and oracle will ask u to enter the value of that column .... if u want to execute the command again just reexecute it .
this is an example :

insert into emp(empno,ename,job,mgr) values (&empno,'&ename','&job',&mgr);

try it .................



bond james bond

as far as I know, there is now way to do a looping in SQL to insert multiple record but you can use a simple PL/SQL to do that looping

Try:

Insert into TableX (Column1, Column2)
Select A, B
Union All
Select C, D

Regards,
Evbo

INSERT INTO emp
select * from
(select 7698, 'Blake', 'Manager', 7839, '01-MAY-81', 2850, 30 from dual) union
(select 1235, 'Bob', 'Executive', 1235, '01-MAY-81', 2850, 30 from dual) union
(select 5465, 'Joe', 'Engineer', 5465, '01-MAY-81', 2850, 30 from dual);

Table Name : MENU_SEASONS
Columns : F_CODE NUMBER(6),F_NAME CHAR(40 BYTE),F_RATE NUMBER(7)

insert statement for multiple rows.

INSERT INTO MENU_SEASONS
( SELECT 1005,'COMBINATIONS OF ARABIC MEEZE',14 FROM DUAL
UNION
SELECT 1006,'ICECREAMS',3 FROM DUAL
union
select 1007,'FROZEN YOGHURT',2 from dual
union
select 1008,'KABABS,SEAFOOD AND TANDOORI',16 from dual
union
select 1009,'ITALIAN BISTRO',14 from dual
union
select 1010,'AMERICAN PIZZA',20 from dual
union
select 1011,'B-B-Q CHICKEN',22 from dual
union
select 1012,'MEXICAN CHICKEN',18 from dual
union
select 1013,'BURGERS / GRILLS',8 from dual
union
select 1014,'ROAST BEEF/BURGERS',10 from dual
union
select 1015,'CHICKEN BURGERS',6 from dual
union
select 1016,'FLAME GRILLED CHICKEN',14 from dual
);

Chandralalprabu S,
Application Engineer,
Intergraph Middle East L L C,
Oman.
       Cell:+96 892669479.

Hi,

If you are uisig .net, then you can insert multiple records with the help of data adapter.

Surendra Parashar
Gurgaon, Hariyana