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...

Ho to insert no. of records at a time..i mean i want to
insert 100 records at a time into a table

Answer Posted / swapna

Example there is a table name emp.It has 100 records
Another table name is dept
Now i want to insert table emp 100 records into dept

--insert into dept select * from emp

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are group functions in oracle?

1038


how to clone 9i Database on to 10g Database.

2334


How to empty your oracle recycle bin?

1017


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2289


what is IDE,DMV in sql server?

2812


Explain oracle’s system global area (sga).

1134


Explain the use of control file?

1104


What privilege is needed for a user to connect to oracle server?

987


How do we represent comments in oracle?

1044


What is a trace file and how is it created in oracle?

1048


How view is different from a table?

1026


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2057


Explain what are the advantages of views?

1064


When do I need to use a semicolon vs a slash in oracle sql?

1087


What are the different oracle database objects?

1087