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 / raghavendra

insert into table 1 value (select * from table2 where
rownum<101 )

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are joins, explain all types of joins?

2297


How to export data with a field delimiter?

1037


What is an external table?

1013


How to convert numbers to characters in oracle?

1029


How to write numeric literals in oracle?

1180


Why does for update in oracle 8 cause an ora-01002 error?

999


What is redo log?

1057


How to select an oracle system id (sid)?

1060


How to use subqueries in the from clause in oracle?

1110


What is literal?

1000


Describe an oracle table?

1049


How many categories of data types?

987


What is integrity and what is constraint??Explain with example

2280


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2172


What are the parameters that we can pass through a stored procedure?

1060