Pl sql inserting updating

Important note: Staring in Oracle 11g release 2, we see the new bulk operator!

When inserting rows in PL/SQL, developers often place the insert statement inside a FOR loop.

Typically, each block performs a logical action in he program.

A block has the following structure: DECLARE /* Declarative section: variables, types, and local subprograms.

This is achieved by the FORALL statement passing an entire PL/SQL table to the SQL engine in a single step.

Internal tests show that this process results in substantial performance increases over traditional methods. This example, assume that a Pro*C program is calling a PL/SQL function for a bulk insert. PROCEDURE customer_insert (p_cust_key IN customer.cust_key%TYPE, p_current_state IN current_state_array, p_anno_user_category IN anno_user_category_array, p_anno_name IN anno_name_array, p_color IN color_array) To properly perform the bulk insert you must get the number of items passed in by the Pro*C program.


By giving your developers the ability to create temporary tables, you can radically improve the speed of certain types of Oracle SQL statements.

The major nuance is that the form of the statement in PL/SQL only works if the result of the query contains a single tuple.


  1. Pingback:

  2. eric   •  

    She is currently working on her first book, a memoir on her personal journey with the niqab as a woman that veils.

  3. eric   •  

    Iedereen gaat in Kamperveen altijd links bij De Hank, omdat het rechts afgesloten is en werkza na de drukke kerstdagen wilde ik even de rust opzoeken tuurlijk mocht/moest witje met me mee ik nam zelf lekker een joggingbroek zonder ondergoed gewoon lekker de boel de boel laten witje moest van mij een jurkje aan zonder ondergoed de glimlach op h Haar rose pumps pasten bij haar pakje het leek op een babydoll die me gelijk al gek maakte ze liep zo door de kamer heen en weer en draaide met dat heerlijke kontje elke beweging was gemaakt om je aandacht te trekken maar ik ging eerst naar buiten, sa Piercings laten zetten.

  4. eric   •  

    Excellent warm up Regatta for upcoming USA National Team Trials.

  5. eric   •  

    Ramo Law PC provides comprehensive legal services to its clients in the entertainment industry with a specialized focus in representing financiers, producers, and production entities in film, television and digital content.

  6. eric   •  

    Every single who's a committed Christian, may join c Match.

  7. eric   •  

    I’m terrible at dating in general, but my go-to online dating move is to get a message from someone cute, and never ever respond. So, when Robyn Exton, the CEO at Her (stylized as HER), a dating app centered on lesbian, bi, and queer women, asked me if I was interested in their latest study on the best hacks for their app, a small, scathing, and very single voice inside me hissed, "You need this." The PR photos didn’t hurt.

  8. eric   •  

    This is fine with me as long as it is okay with my daughter.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>