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

How to find schema of a table in db2?

1063

Define buffer pool.

1097

List out the three types of page locks that can be held.

1191

What is difference between alias and synonym in db2?

1193

How do you pull up a query which was previously saved in qmf?

1202

What are catalog tables in db2?

1104

What is cobol db2?

1039

Define db2 and its databases?

1109

How to view db2 table structure?

1059

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1127

Can there be more than one cursor open for any program?

1223

What is explain plan in db2?

1048

How will you return the number of records in table?

986

What is the advantage in De-normalizing tables in DB2?

1227

How can you find out the # of rows updated after an update statement?

1154