-
Junior Member
Insert in a table
What is the best way to insert 100000 records in a table considering the performance issue.
i mean data should be added in the table with least possible time.
-
Re: Insert in a table
You need to use FORALL statement using PL/SQL.
-
Junior Member
Re: Insert in a table
use the insert with select clause and also use the append hint which is used for direct path insertions.
insert /*+ append */ into select ;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules