Oracle PL SQL interview question CURSOR Vs COLLECTION

Oracle PL SQL interview question CURSOR Vs COLLECTION

[arunrocketz]

YOU ARE A TREASURE OF OUR COUNTRY.. YOU SHOULD BE PROTECTED.. Continue ur good work

[zramzscinece_tech]

Your explanations are excellent, Please keep posting PLSQL related videos.

[gsraj]

Thanks Siva for your detailed explanation...

[ravikhanna]

Hi Siva,
By seeing above video i am able to analyze the scenario where collection is better than cursor.
So Could you please provide any scenario where usage of cursor is better than collection.

[SreeramReddyB]

Can we directly assign to out parameter from select bulk collect into statement ?

[kunuturuaravindareddy]

simply superb clear and easily understandable

[sridhartamilselvan]

Thanks for this topic sir... I got some ideas from it.

[rahulbadhe]

nice session sir, ,
thank you so much.

[vineetadola]

One doubt: here you use bulk collect for storing the data into nested table .... But usually we can use extend function in collection and save the data right?? What is the use of bulk collect over extend function??

[uditkumar-vghb]

Hi Siva, u are explaining with python ..can u start and provide the learning videos of python as well.
THANKYOU🙂

[suchitapatil]

Hi sir please plz explain when we should use package and procedures

[vinayakavini]

Super explanation. I have one query. When do we use cursors and insert script?

[manishsahu]

Very Nice learning through ur video. Thums up!

[padmapriya]

Hi sir thanks for the detailed explanation. Can u please do one video for in which scenario we should use each plsql concepts

[poojalonibarhanpure]

Hi sir, you have called a get emp list proc from python n fetched the row. As the cursor is open in oracle procedure doesn't it need to be closed? If yes then how to close the ref cursor.
As it gave me a security concern that the cursor is not closed

[mathankumar]

So based on our business requirement we need to choose whether to use refcursor or collection.. am I right sir? Or can we use collection as a outparameter to front end always? So that the db usage will be reduced

[lakshmanakumart]

if oracle forms 12c and Reports 12c can work with Oracle 11g DB?

[photomyste]

Here why we don't use extend in nested array

[WorldEye]

So collections are more efficient for the DB resources?  Thank you.  Very nice

[gurumoorthysivakolunthu]

Hi sir... Thanks a lot for your effort.... 1 doubt, Sir -- while using refcursor as out parameter... -- we are not closing the cursor both in procedure and in the calling anonymous block...
... Will the cursor closes automatically ...?