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
- 20015 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
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How is the value function used?
Explain the benefits you can get from mainframe connect?
How do I copy a table in db2?
What is the difference between plan and package in db2?
What is phantom read in db2?
How do I optimize a query in db2?
Define check constraint.
What is database manager in db2?
What is null indicator in cobol db2?
What are the various data types available in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is innodb buffer pool?
What is the use of reorg in db2?
What is db2 connect?
