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

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

What is the difference between hot backup and cold backup in oracle?

958

What are set operators?

1032

How to delete all rows a table in oracle?

1010

Calculate difference between 2 date / times in oracle sql?

987

What is a procedure in oracle?

1075

What is ADDM Advisor in Oracle?

1117

What is dynamic proxy?

963

What is the quickest way to export a table to a flat file?

920

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

What is a table index in oracle?

1070

How many types of database triggers exist?

1068

What happens if you set the sga too low in oracle?

1054

How to select some columns from a table in oracle?

1005

How to create an initialization parameter file?

985