Insert in a table

[raj_imr2000]

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.

[debasisdas]

You need to use FORALL statement using PL/SQL.

[expertsharingdotcom]

use the insert with select clause and also use the append hint which is used for direct path insertions.

insert /*+ append */ into select ;