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 / ratheesh nellikal

U could probably go for a bulk insert also.
try this option

insert into schema.table1
select * from schema.table2;

Cheers,
Ratheesh Nellikal

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is load utility in db2?

1229


What is buffer pool and list some of them?

1093


What are the various data types available in db2?

1145


What is dbrm? What it contains? When it will be created?

1101


What is a bind card?

1278


How to find the maximum value in a column in the db2 database?

1126


How to find the number of rows in a db2 table?

1154


what is db2 restart?

2213


Why db2 is called db2?

1105


What is the use of predicate?

1085


What is ibm db2 connect?

1054


what is diffrence b/w file-aid tool and file-aid utility???

4959


What types of tables are there in the db2 database?

1101


Where do you specify them?

1370


Explain packages.

1169