Do an Insert using select Insert into Table1(coltable1, coltable22)(select

How to insert more than one record using insert?

Question Posted / subi

Answer Posted / subi

Do an Insert using select
Insert into Table1(coltable1, coltable22)(select coltab21,
tab2col2 from Tab2 where <condn>)

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain about open switch business continuity software?

1135

Mention the various locks that are available in db2.

1041

What are union and union all?

983

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

What is null indicator in cobol db2?

1067

What is role in db2?

1109

How can you classify the locks in db2?

1089

What is database reorganization?

1128

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

1393

What are the various data types available in db2?

1094

Can we delete records from view?

967

Define db2.

1119

What is the maximum size of varchar data type in db2?

1137

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

1149

What are the different types of base tables?

1096