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
What is dclgen (declaration generator)?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is copy pending and check pending in db2?
What is blu acceleration in db2?
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
How do I add a column in db2?
What are the various data types available in db2?
Name the various locking levels available?
What is dpf in db2?
What is the syntax for creating a table in the db2 database?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can you count the number of rows from a table tab?
Explain various types of locks in db2?
Mention some fields that are a part of sqlca.
what are bind concepts in db2 cobol?