Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to insert more than one record using insert?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning concurrency in the db2 database?

1105


What r the comman abends in db2, jcl and cobol???????

2250


What is the use of with ur in db2?

1047


Why db2 is called db2?

1021


What is db2 connect?

1058


How to find primary key of a table in db2?

1054


How to find the number of rows in db2 tables?

1053


What are the prerogatives?

1069


What's The Error Code For Unique Index Voilation?

1218


Why cursor is used in db2?

1030


What is meant by union and union all?

1004


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8262


How and when does the db2 enforces the unique key?

1076


What is difference between alias and synonym in db2?

1128


What are the benefits of using the db2 database?

1219