HomeНаука и техникаRelated VideosMore From: Practically Perfect PL/SQL with Steven Feuerstein

BLK2: Get Data Faster with BULK COLLECT (PL/SQL Channel)

60 ratings | 6948 views
This lesson explores the BULK COLLECT feature, which allows you to retrieve multiple rows of data from the SQL layer with a single fetch. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Html code for embedding videos on your blog
Text Comments (3)
Paul White (5 months ago)
excellent, thank you!
Rajeev K (1 year ago)
Does data flushes from memory using Limit clause, I have following code. Will it work for 1 billion records. My question is that will all data remain in memory after completion of loop. OPEN CUR_CQ; LOOP FETCH CUR_CQ BULK COLLECT INTO CQ_TABLE$ LIMIT 100; EXIT WHEN CUR_CQ%NOTFOUND; END LOOP; CLOSE CUR_CQ;
Abhishek Kumar (2 years ago)
thank you sir

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.