Oracle PL SQL interview question difference between VARRAY NESTED TABLE ASSOCIATIVE ARRAY

Oracle PL SQL interview question difference between VARRAY NESTED TABLE ASSOCIATIVE ARRAY

[akankshamudedla]

Thank you for the video. I have always confused with these. Now cleared my doubts to do much

[AmitPandey-onhh]

after watching this vedio, i have cleared lot of doubt. thank u sir....

[sujaa]

Thank you, very clearly explained and helped me understand better.

[amyroseplayingandfun]

I have become a fan of your really nice videos

[Seema_Cute]

Videos are so simple and clear to understand the concepts

[nuthan]

LIMIT is applicable for all type where as it return NULL is case of NESTED table and associative array ( No compilation erro)

[mohamedheba]

Keep it up. Thank you so much for the clarification. very useful.

[ramramaraju]

Thanks Siva. Good video on collection differences.

[rtrkings]

Super siva excellent explanation really I enjoyed this video

[sudhakar]

Your all videos are very helpful. In this i am having one doubt why we cant use the data type NUMBER in index by of Associative Array. I know oracle won't accept but i what to know whether any specific reason for this. Thank you

[gsraj]

Great Siva... Applause's for your Great effort :)

[TheHarishAgarwal]

I think what you are calling Nested Table is a PL/SQL Table. Nested Table in an entirely different concept and is stored within a table column vs a data structure used in a PL/SQL Program. Please correct me if you don’t agree.

[jagnyaseni]

Hi sir, what will be the answer for( what is the difference between block and procedures)..asked in an interview.. please explain sir..

[learnCodingTechguru]

Hi Sir,
In most interview, interviewer ask which collection type used in your project and why and which collection type performance is fast. Pls explain

[shripadkulathe]

In the initial of this video, you said we can't delete particular index of varray by using delete but at time differences you said we can use delete on varray, please clarify .

[azharsha]

You're rocking bro ❤️keep post for us 👍🙏

[sandeepbadvel]

Thank you very much for the information shared. Could you please clarify how Delete(n) method is applicable for VARRAY ?as the method makes the collection sparse which is not true in case of VARRAY.

[shashank]

Nice video sir, In associative array Syntax is
Type t1 is table of varchar2(10) index by binary_integer or pls_ integer
So what the difference between binary_ integer and pls_ integer? Pls explain

[shobharani]

Nice video Siva.what are the possible collection exceptions that would be raised during execution

[ganeshsah]

Hi Shiva, Thanks for all important topics related to Interview.
Why associative Array doesn't create on Schema Object like V-Array and Nested Table and when we use associative array?
I have seen all your video but these two points I have not understood yet.
Please help me out.