How to insert more than one record using insert?

Answer Posted / sandeep kumar

insert into tablename(col1, col2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
....................
....................

Is This Answer Correct ?    7 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give a brief description of db2 isolation levels?

689


What is the use of reorg in db2?

698


What does a deadlock mean in DB2?

742


Explain the function done by data manager?

926


How does coalesce work?

670






What is concurrency?

799


What is the use of db2?

681


is it compulsory commitment control in journal?

2087


How can you count the number of rows from a table tab?

722


What is difference between isnull and coalesce?

689


What is syscat in db2?

663


What is catalog database in db2?

749


What is db2 catalog database?

659


What is declare cursor?

706


What are catalog tables in db2?

685