Here is the complete question: RE: FORALL BULK INSERTS (oops)

Sent this too soon last time... too used to hitting tabs in editors... damned web forms! :-/ :-)

Once again from a relative PL/SQL newbie,

All the articles and/or examples I have seen for bulk binding use elements belonging to some sort of collection, or grabs a cursor in order to place something in a collection to be used in the forall or bulk collect statement. I am inserting (as part of some pro*c embedded pl/sql) into a table using something like the statement below. The question is, is it possible to 'bulk up' with something like this statement? If so, can someone provide an example or template or push in the right direction? I have looked through the newsgroup and in Oracle docs and can't seem to find any info that fits this situation. Also, will it provide any performance benefit in this situation?

Here is the example code:

INSERT INTO MYTABLE(

            SELECT VALUE1,VALUE2,VALUE3,ETC
            FROM   TABLE_ONE
            WHERE  A_BUNCH_OF_CLAUSE_THINGS_GOING_ON

            SELECT VALUE1,VALUE2,VALUE3,ETC
            FROM   TABLE_TWO
            WHERE  A_BUNCH_OF_CLAUSE_THINGS_GOING_ON

            UNION

            SELECT VALUE1,VALUE2,VALUE3,ETC
            FROM   TABLE_THREE
            WHERE  A_BUNCH_OF_CLAUSE_THINGS_GOING_ON)


------------------------------------------------------

Thanks for any help. Sorry about the previous, inadvertently sent, half composed post on this. :-)

BillR in stl Received on Mon Jun 10 2002 - 13:51:51 CDT