In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
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
Which isolation level provides highest data integrity?
Which component is responsible for db2 startup and shutdown?
What is a trigger in the db2 database?
What is dbrm?
What is the use of db2?
What is the purpose of rollback and commit?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is page size in db2?
What is performance tuning db2?
Can you use max on a char column?
Is ibm db2 free?
How is deadlock resolved?
What is database reorganization?
How do I connect my db2 database to ibm?
When reorg is used?