COL3: Working With Collection Methods

[@joaquimcassiano5238]

Thank you Steven. Very helpful and clear presentation.

[@sreekanthmunagala]

Thank you for taking the time in sharing this video and the great content in it Steven. As the channel name indicates, the content that you provide us here is exactly what we need to write a practically perfect piece of PL/SQL code and the way you explains makes it very easy to understand. I would like to ask the question that came to my mind when going through the EXTEND method. Why should only nested tables and varrays be explicitly initialized and not associative arrays ? What exactly oracle does in the background during variable declaration and initialization of a nested table or varray?

[@mahasridhar]

Thanks for the videos. It is so very useful.

[@mercyjhansi2427]

I'm able to use delete for varrays without specifying which index to be deleted, which deletes all the elements in the varray. Only delete method with index specification doesn't work for varrays. So, why is it told varrays don't support delete completely?

[@PracticallyPerfectPLSQL]

Mercy, thanks for pointing this out. You are absolutely right. You can delete all elements in a varray, you just can't specify start and end index values.

[@mercyjhansi2427]

@@PracticallyPerfectPLSQL Thanks for your reply. I like the way you teach so much. You are my biggest inspiration. Thanks a lot for all the videos.

[@s123square7]

thanks for sharing

[@afsarali92]

Thanks for the video :)

[@rajit1710]

If i describe your videos in words, i would be the idiot of the century...

[@shevani930]

Sometimes the screen is blurred ,otherwise its very informative .