In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
Answer Posted / shekhar
insert into table1
select * from table2
where cond
this query will insert multiple rows at once.
there is load utility of DB2 can help in inserting bulk data from data file.
Plz correct me if i m wrong.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is runstats db2?
What is cascading rollback?
What is lock escalation in db2?
Which is faster delete or truncate?
How do I delete a table in database?
What is the picture clause of null indicator variable?
What is the use of reorg in db2?
Define db2 and its databases?
What is the difference between oracle and db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is db2 bind process?
What kind of database is db2?
What is the use of commit in db2?
What are the uses of db2 optimizer?
What is a collection in db2?