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
- 5 Answers
- 10638 Views
- I also Faced
- E-Mail Answers
Answer Posted / ron
i assume you are doing batch processing (say processing of
millions of rows):
1. add a new column to the table say t2 called
processed_rows char(1) not null default of 'N'
2. in a pl/sql block (start loop);
update processed columns to 'P' for processing
where rownum<101;
2. if rowcount after update=0 exit loop.
3. next insert into t1 select from t2 where processed_rows='P'
4. update t2 change column from 'P' to 'Y (saying processed)
6 commit;
7. loop until all rows are processed.
8. advantages. you can restart the process after failure.
and done have to start all over again only those that that
have not been processed will be processed.
to improve performance is millions of rows are being
processed then:
partition the table table;
and run the above sql against each individual partitions;
processing will be done that many times faster.
good luck!
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Give the different types of rollback segments.
What is the difference between formal parameters and actual parameters?
What are the common oracle dba tasks?
Whats the benefit of dbms_stats over analyze?
What are the predefined tablespaces in a database?
What is a database schema in oracle?
What suggestions do you have to reduce the network traffic?
How to do clean up if create database failed?
When do we use group by clause in a sql query?
Explain about integrity constraint?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the different types of failures that occur in Oracle database?
Explain table?
What is Trigger in Oracle?
When do you get a .pll extension in oracle?
