COL1: Introduction to Collections

[@sundaramnarayanan6776]

Stephen you are so great. From your video only I understood the logic of limit clause in bulk colectt. You are amazing bro. Thanks to youtube.

[@emanuelvald]

Hi Steven, I appreciate your time to upload these tutorials, I suggest you add english subtitles to videos for non-english speakers people. Thanks!!!

[@PracticallyPerfectPLSQL]

Thanks, we will look into doing this.

[@siddhartharao8490]

Nice video...I would like to know the main difference between cursors and collections?

[@anilmohanty8690]

collection gives more fuctionality in different way..cursor is forward direction only we cannot back but in collection we can fetch data using collection method.

[@vickypatekar9532]

Steven Sir, you are Awesome but Pls also Provide Subtitle I miss some of your Words its too difficult Understand the Missing Words...🙏 thanks again

[@AshishSingh-qu3ns]

Can you give example of collection of record types

[@PracticallyPerfectPLSQL]

DECLARE TYPE employees_t IS TABLE OF employees%ROWTYPE; TYPE my_rec_t IS RECORD (n NUMBER); TYPE my_Recs_t IS TABLE OF my_Rec_t;

[@AshishSingh-qu3ns]

Practically Perfect PL/SQL with Steven Feuerstein ... Thanks a lot Steve.. will keep you busy in coming days.. going through all your tutorials 😊

[@s123square7]

sir, thankyou

[@technologyfollowing2820]

Hi Steven...Good info on collections..Very useful..Would you tell me how to download your demo.zip file..?

[@PracticallyPerfectPLSQL]

www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip. p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Helvetica; color: #555555; -webkit-text-stroke: #555555; background-color: #f6f6f6} span.s1 {font-kerning: none}

[@MacK-uh7ix]

@@PracticallyPerfectPLSQL Hey Steven, the link does not work anymore. Any other place that this archive file is available?

[@rajgauravmaurya3067]

Hi, the resource (demo.zip) is not available on the shared link. Please share the working link again.

[@karan_2892]

I get insufficient privileges error while trying to provide grants on those tables , I'm able to query those tables but I cannot access them through PL-SQL procedure . I'm Logged in through System user , I guess it should have all privileges to provide grants... Any suggestions ? I'm practicing on Oracle Express edition 11g . GRANT SELECT ON SYS.V_$SESSION TO INVENTORY1; GRANT SELECT ON SYS.V_$sesstat TO INVENTORY1; GRANT SELECT ON SYS.V_$statname TO INVENTORY1; ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" I get above errors while being connected through SYSTEM . I had given below grants to inventory1 while creating it CREATE USER INVENTORY1 IDENTIFIED BY INVENTORY1; GRANT CONNECT, RESOURCE, DBA TO INVENTORY1; GRANT CREATE SESSION, GRANT ANY PRIVILEGE TO INVENTORY1; GRANT UNLIMITED TABLESPACE TO INVENTORY1;

[@PracticallyPerfectPLSQL]

When you connect as SYSTEM, be sure to do as SYSDBA. Then your grant should work fine.

[@shanawazali6161]

Please