Collections in Oracle PLSQL

Complete Oracle PL/SQL Tutorial for Beginners Playlist here
**************************************************

Composite DataType - Collections in Oracle PL SQL
1. Difference Between Records and Collections
2. Types of Collections in Oracle
3. VARRAYS
4. Nested Table
3. Associative Arrays / Index BY Tables
4. Multi Dimensional Arrays Using Collections and Records

[CB-xkce]

This was even better/clearer than the official Oracle tutorials, thanks!

[rexjuggler]

This is the best tutorial series I have found for PLSQL. I've been studying and searching for quite a while. I have 3 books on PLSQL. This tutorial is perfect. Each subject is covered in perfectly sized modules. Good job! I hope you continue to put together these types of tutorials.

[sushmitapriya]

This is what I was searching since last 2-3 days. Thanks for sharing your knowledge !!

[affanpk]

Best explanation for collection with practical example..keep it up 👍

[mmohan]

Ur my god sir .ur video made me to get a job in one of the mng company

[mohan]

Hi! Thanks, Your videos make it easy to grasp the subject, good job!

[mauricioroldanramirez]

Could you share the link of the second part for the video Collection functions? please? I could not fid it

[KabergOficial]

can I put a variable in place of 5? Exp: Declare v_qtde integer := 5; type t_array1 is !but this variable being of the type number or integer plsql complains that it is not integral.

[vijayrajjakhmola]

best video to understand collection, but sir please explain "Associative Array" . Thanks so much

[sujith.g]

Bro how to get values for varray from user (dynamically) in oracle

[bsramkrishna]

How to fetch no of records from cursor to collection?

[krishnad]

Hi, very good explanation. Can you provide example for Associative arrays as well and also could you explain when to use them, I mean among 3 collections when to use when.

[deepaktheproudindian]

Can anchored data types be used in temporary tables?

[kumarmacha]

Hi Can you please help in following.

How to assign the values as following
student_ids(1).st_id := 5;
student_ids(1).name := 'Kumar';
student_ids(1).marks := 50;

[rakeshk]

Hi,
Where is third type Associative Array/Index by Table ? I Missed ?

[RAMPRASAD-svis]

Very Good Explanation.Please Upload the Videos for Bulk collect and ref cursors

[satya]

Very Good Explanation, Upload a Video Of regular expression

[sharmisthasahoo]

Hi, can you please upload the associative array with bulk collect explanation asap?

[SudhirBhajnawale]

Hi,
Thanks a lot sir, well explained .

[satvinderbhangu]

My only question is why we need array if we have cursor . We can same thing do with cursor. Can you tell me please what is main purpose of array and why we use in plsql. Thanks