Interested to Buy Any Domain ? << Click Here >> for more details...
In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
- 5 Answers
- 19935 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / siri
insert into tableName
(col1, col2, col3, col4, col5)
values
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5);
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How can we retrieve the total number of records in RPG & CLLE?
How do I import data from excel to db2?
What is dbrm? When it will be created?
What is dbrm? What it contains? When it will be created?
How can you classify the locks in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is plan in cobol db2?
How do you select a row using indexes in db2?
How to execute stored procedure in db2 command editor?
Which component is used to execute the sql statements?
What is null value in db2?
Explain about rct.
What are the uses of db2 optimizer?
How do I change the column size in db2?
