PL/SQL tutorial 73: Bulk Collect with SELECT-INTO statement in Oracle Database

------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial

-------------------------------------------------------------------------
►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

___Facebook Official Page of Manish Sharma___

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[sharpazn]

Almost 100k subscribers, congratulations!!!!
Hey do you have a series on Oracle Apex? it would be awesome!!!

[abidalica]

This is just great stuff, thanks for the video, love and respect from Pakistan, just subscribed

[singamsivagangireddy]

Hi Manish, Can you please upload the videos on oracle database architecture.

[daggerdudes]

hi bro could you tell me why you mentioned fname(idx) as we can get the data directly with fname itself

[yogitachoudhary]

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?

[rohinithakre]

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

[surjeetkarmakar]

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.

[devinenibalaji]

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...

[daminirawat]

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 ??

[hello]

what happens when in bulk collect batch there is some error, will it gets failed?or continue to fetch??

[aleenshrestha]

can we use object type instead if nested table

[krom]

I need use two tables en FROM clause, how do i make it?

[pratikdixit]

Why we have not initilized fname with constructor nt_fname() plz tell

[photomyste]

Why u didn't use the extend in nested array

[vickypatekar]

Hello Sir I cannot able to watch this video...As it Buffering

[mahekaslam]

Hello sir, why this video is blurred m not able to view the videos

[lucasalvarez]

Excelente tutorial faltaría el subtítulo en español nomas!

[stanika]

Is this possible in bulk collect insert

[satya]

Hi Manish, Can you please upload the videos on oracle database architecture.