COL4: Working with Associative Arrays

[@jatinsview]

This is the only video which i prefer to see before interview. After 5 years i am again here to prepare for interview.

[@likithagunda6753]

Awesome explanation..! Thank You very much Steven..!

[@bbujjin3899]

Hi Steven your plsql channel is very useful and learn so many new things thank you so much

[@PracticallyPerfectPLSQL]

Many thanks, BB! Please do also check out devgym.oracle.com for another great way to learn!

[@bbujjin3899]

Practically Perfect PL/SQL with Steven Feuerstein Ya sure !but before pls let me conclusion of devgym oracle

[@surajmokatkar]

Nice Clear Explanation...Thank You for the videos..

[@rupeshkumar5157]

Nice explanation thanks for the videos ... :)

[@HeshamAbuElenain]

Professional

[@nasimchaklader126]

Hi SteveCan I use something like thisSELECT EmailBULK COLLECT INTO v_email_aat LIMIT 1000FROM my_tabe;My question is : can I use LIMT here.Thanks

[@PracticallyPerfectPLSQL]

No you can only use the LIMIT clause with a FETCH statement. OPEN cursor; FETCH cursor INTO collection LIMIT N.

[@siddharthapenchala8146]

Can u please tell me what is the use of associative arrays in real time?

[@SinskariBoi3366three]

TYPE associative_array_type IS TABLE OF datatype [NOT NULL] INDEX BY index_type; Now, the following real time example declares an associative array of character indexed by characters: TYPE t_capital_type IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(50);