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

Write a trigger example in oracle?

1063

Can we write dml statement in function in oracle?

1081

What is a sub query? What are its various types?

1179

How to manage transaction isolation level?

1006

How to export data with a field delimiter?

1039

How many types of cluster table in Oracle?

1034

What are the major difference between truncate and delete?

1058

Can we create trigger on materialized view in oracle?

992

What is columnar storage what is the advantage?

1063

What happens to the data files if a tablespace is dropped?

1059

How to convert character types to numeric types?

1132

How to rename an existing table?

1129

How to specify default values in insert statement using oracle?

1104

How to use "startup" command to start default instance?

1033

Does oracle partitioning improve performance?

992