If we want to insert more than 1 row into a table , we should go for SUBQ

How to insert more than one record using insert?

Question Posted / kalone

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

Please Help Members By Posting Answers For Below Questions

Explain various types of locks in db2?

685

What is database reorganization?

587

What is the physical storage length of date data type?

722

What is the purpose of using commit?

614

Is it possible using max on a char column?

599

Which are the db2 tools to protect integrity of the database?

684

What does reorg do in db2?

573

What is db2 connect?

599

What is check constraint. Explain with example.

642

can we view the access paths created by dbrm ? how ? thx

6236

What are db2 tables?

641

How do you find the maximum value in a column in db2?

646

Why cursor is used in db2?

572

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

638

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

714