Bulk Binding is used for avoiding the context switching between the sql engine and pl/sql engine. If we use simple FOR loop in pl/sql block it will do context switching between sql and pl/sql engine for each row processing that degrades the performance of pl/sql block. So that for avoiding the context switching between two engine we use FORALL keyword by using the collection pl/sql tables for DML. FORALL is pl/sql keyword.
To do bulk binds with Select statements you include the Bulk Collect INTO a collection clause in the SELECT Statement instead of using simply into. It will provide good result and performance increase.
No comments:
Post a Comment