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

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

Question Posted / raghavendra

Answer Posted / raghavendra

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

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to select some rows from a table in oracle?

1129

Differentiate between pre-select and pre-query?

1157

Give the advantages and disadvantages of clusters.

1097

Is oracle an open source?

1128

How to connect to a local oracle 10g xe server?

1033

How to define an anonymous block?

1247

How to check the server version in oracle?

1144

What is the usage of analyze command in oracle?

1142

What are temporal data types in oracle?

1171

What is flashback in Oracle?

1063

What are the differences between interval year to month and interval day to second?

1067

What are the components of logical database structure in oracle database?

1139

What is system global area (sga) in oracle?

1035

what is difference between sql plus and sql*plus? (not sql and sql plus).

3943

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

2357