In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
Answer Posted / uma
We can't insert multiple row in single query for the we
have to use cursor.
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
Which component is used to execute the sql statements?
what is db2 restart?
What is view db2?
Which is faster delete or truncate?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the physical storage length of time data type?
Mention the different locking levels that are available in db2.
What is cursor in dbms?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is reorg?
Which isolation level provides maximum concurrency?
Explain correlated sub-queries.
What is buffer pool?
What are the various isolation levels possible?
How do I add a column to a table in db2?