PL/SQL (MOSC)

MOSC Banner

Ask about INSERT with three options

edited May 30, 2012 10:01AM in PL/SQL (MOSC) 9 commentsAnswered
Hi,

   A question about INSERT,

  I have about 1 million records and need insert into table. Ok, I gave three solutions:

    1. INSERT INTO <table1> SELECT ... FROM <table2>

    2. Use BULK COLLECT INTO <collection_array> LIMIT 100 and use FORALL to insert data into <table2>

    3. Use INSERT /*+ APPEND*/ INTO <table1> SELECT ... FROM <table2>

  I am a fan of using BULK COLLECT and LIMIT.

    Can anyone give me some advise about them and which method is best ? My db is 9.2.0.4

  Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center