How to insert more than one record using insert?
Answer Posted / ratheesh nellikal
U could probably go for a bulk insert also.
try this option
insert into schema.table1
select * from schema.table2;
Cheers,
Ratheesh Nellikal
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is load utility in db2?
What is buffer pool and list some of them?
What are the various data types available in db2?
What is dbrm? What it contains? When it will be created?
What is a bind card?
How to find the maximum value in a column in the db2 database?
How to find the number of rows in a db2 table?
what is db2 restart?
Why db2 is called db2?
What is the use of predicate?
What is ibm db2 connect?
what is diffrence b/w file-aid tool and file-aid utility???
What types of tables are there in the db2 database?
Where do you specify them?
Explain packages.