Stop Avoiding Bulk-Binds (FORALL)
{"Image DocumentName": "Stop Avoiding Bulk-Binds (FORALL)", "Image ImageDescription": "Bind data in collections into DML using FORALL. (insert_forall.sql) Triggers may not work as you expect. Use INDICIES OF and VALUES OF for sparse collections. Use SQL%BULK_ROWCOUNT to return the number of rows affected by each statement. The SAVE EXCEPTIONS allows bulk operations to complete. Exceptions captured in SQL%BULK_EXCEPTIONS. FORALL i IN l_tab.FIRST .. l_tab.LAST. INSERT INTO tab2 VALUES l_tab(i);", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}