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
- 20192 Views
- CTS, I also Faced
- E-Mail Answers
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
How do you find the maximum value in a column in db2?
How do I add a column in db2?
Is schema the same as database?
Define check constraint.
What is declare cursor?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Name the lockable units in DB2?
What is a db2 schema?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How to check last update on table in db2?
Highlight all the advantages that are attached to a package.
What is a db2 collection?
What is a bind card?
What is buffer pool and list some of them?
