PL/SQL tutorial 73: Bulk Collect with SELECT-INTO statement in Oracle Database
ฝัง
- เผยแพร่เมื่อ 21 ก.ย. 2024
- RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: www.rebellionr...
Previous Tutorial
►Introduction to Bulk Collect: • PL/SQL tutorial 72: In...
►PL/SQL Tutorial 51-Nested Table: • PL/SQL tutorial 51: Ho...
►Collection Method Count: • PL/SQL tutorial 59: PL...
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
/ rebellionrider
/ rebellionrider
plus.google.co...
/ mannbhardwaj
__Facebook Official Page of Manish Sharma__
/ therebellionrider
__Facebook Official Page of RebellionRider.com__
/ rebellionrider.official
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Almost 100k subscribers, congratulations!!!!
Hey do you have a series on Oracle Apex? it would be awesome!!!
This is just great stuff, thanks for the video, love and respect from Pakistan, just subscribed
Hi Manish.. good video... I have a doubt.. here the collection is holding data of type varchar .. if while extracting the data from employee table if it has any other data type other than varchar what would be the scenario... like it will still hold the records before error.. can you pls explain this...
Great bro
awesome manish bai...keep going
Manish sir...this was a simple example thanks for as usual awesome video...But in a real time senario for e.g. out of 10 records there is an error in one records...what happens in this situation???
will whole bulk operation fails..? or what...really waiting for the ans for it
Hi Manish, Can you please upload the videos on oracle database architecture.
Hi,
Could you please explain if you mentioned size is varchar2(20) of a type variable then how all 107 records are holding in this m confused please clear my doubt ??
hi bro could you tell me why you mentioned fname(idx) as we can get the data directly with fname itself
Hello Sir I cannot able to watch this video...As it Buffering
Your video was really very helpful, but i have a doubt. Suppose i want to select a single row with 5 cloumns from a table and put it into another table. So will the bulk select statement be helpful here?
can we use object type instead if nested table
what does use multiple columns ?
I need use two tables en FROM clause, how do i make it?
Why we have not initilized fname with constructor nt_fname() plz tell
Thanks for this Bro
Why u didn't use the extend in nested array
what happens when in bulk collect batch there is some error,will it gets failed?or continue to fetch??
Hello sir,why this video is blurred m not able to view the videos
Mahek Aslam Net slow hoga tumhara
Excelente tutorial faltaría el subtítulo en español nomas!
can we do this without using loop😊
Yes you can use FORALL instead of FOR loop here.
Hi Manish, Can you please make a video for managing different users(sys, HR etc) and there password for Oracle Database 12c Release 2 ((12.2.0.1.0) - Standard Edition 2 and Enterprise Edition). This will be a great help.
Is this possible in bulk collect insert
Hi Manish, Can you please upload the videos on oracle database architecture.