0

How to insert data into table.

Insert into TEAMS (TEAM_CODE,TEAM_NAME,TEAM_DIVISION,TEAM_CITY,TEAM_STATE,TEAM_COACH,TEAM_STADIUM,TEAM_STAD_CAP)        
VALUES                    
('BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''),      
('BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''),      
('BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''),      
('BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''),      
('BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''),                    
('NEP','New England Patriots','AFC EAST','Foxboro','MA','Bill Belichek','Gillette Stadium','');

Can we Insert multiple data using one single command ?

Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
Dipenkumar Shah
  • 11

1 Answers1

0
Insert into TEAMS (TEAM_CODE,TEAM_NAME,TEAM_DIVISION,TEAM_CITY,TEAM_STATE,TEAM_COACH,TEAM_STADIUM,TEAM_STAD_CAP)
            select 'BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''
union select 'BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''
union select 'BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''
union select 'BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''
union select 'BUF','Buffalo bulls','AFC EAST','Buffalo','NY','Doug Marrone','Ralph Wilson Jr.Stadium',''
union select 'NEP','New England Patriots','AFC EAST','Foxboro','MA','Bill Belichek','Gillette Stadium','';
Sathyajith Bhat
  • 21,321
  • 22
  • 95
  • 134
TonyP
  • 5,655
  • 13
  • 60
  • 94
  • You can't just `SELECT` in Oracle. You need to select from something, eg `dual` – cha Sep 11 '14 at 05:41
  • And while you are at it fix your `UNION SELECT`. Replace it with `UNION ALL SELECT`, otherwise the first five rows will be inserted as one – cha Sep 11 '14 at 05:45