How to insert more than one record using insert?
Answer Posted / subi
Do an Insert using select
Insert into Table1(coltable1, coltable22)(select coltab21,
tab2col2 from Tab2 where <condn>)
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the meaning concurrency in the db2 database?
What r the comman abends in db2, jcl and cobol???????
What is the use of with ur in db2?
Why db2 is called db2?
What is db2 connect?
How to find primary key of a table in db2?
How to find the number of rows in db2 tables?
What are the prerogatives?
What's The Error Code For Unique Index Voilation?
Why cursor is used in db2?
What is meant by union and union all?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How and when does the db2 enforces the unique key?
What is difference between alias and synonym in db2?
What are the benefits of using the db2 database?