How to insert more than one record using insert?

Answer Posted / kalone

If we want to insert more than 1 row into a table , we
should go for SUBQUERIES rather than VALUES clause.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the role of data manager in the db2 database?

834


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1900


How can the duplicate values be eliminated from db2 select?

843


How to retrieve rows from a db2 table in embedded sql?

959


If I have a view which is a join of two or more tables, can this view be updateable?

891


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1813


Who uses db2?

742


List down the types of triggers in the db2 database?

761


What are concurrency issues?

796


What is db2 command?

764


i want to maintain uniqueness on pdf without make lf??????????

1884


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

803


What is isolation level in db2?

745


What is dclgen in db2?

871


List down the data types in the db2 database.

801