Oracle PL SQL interview question CURSOR Vs COLLECTION

[@arunrocketz]

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

[@SivaAcademy]

It's my pleasure,Thank you

[@ravikhanna29]

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.

[@vineetadola1547]

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??

[@SreeramReddyB]

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

[@kunuturuaravindareddy5580]

simply superb clear and easily understandable

[@SivaAcademy]

Thank you bro

[@uditkumar-vg5hb]

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

[@suchitapatil4525]

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

[@photomyste3279]

Here why we don't use extend in nested array

[@swarnali11]

Very good detail explanation ...Thanks a lot :)

[@SivaAcademy]

Thank you

[@poojalonibarhanpure2212]

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

[@ankitvarshney15]

I think, it is getting closed in Python code... cur.close()

[@mathankumar2228]

Then y we use ref_cur as a out parameter while Collection is doing it in single fetch?

[@SivaAcademy]

If you have limited data, then you can send via collection, if you have huge amount of data, then it's not recommended to return as collection.... Via ref cursor we are just returning the pointer, not the data

[@mathankumar2228]

@@SivaAcademy ok thank you sir

[@gsraj511]

Thanks Siva for your detailed explanation...

[@SivaAcademy]

My pleasure 😊

[@ajeet382]

awesome work man

[@radhachikkarangappa4132]

Can you please give a session on Explain plan and Oracle hints

[@SivaAcademy]

Sure please stay tuned

[@priyankadesai9848]

Please sir

[@zramzscinece_tech5310]

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

[@SivaAcademy]

Thank you,Sure, Please stay tuned

[@bhushanpalse516]

Excellent Explanation...sir

[@SivaAcademy]

Welcome bro

[@srarts6990]

Can we create a materialized view on two different schema tables..?

[@SivaAcademy]

Yes you can

[@srarts6990]

@@SivaAcademy Write a procedure to create views for all tables at a time? I got this question from one of interview. Will you help me on that sir..

[@SivaAcademy]

Definitely Sai, I am preparing view related interview question, mostly I will be posting this week, I will add this question also as part of that, please stay tuned 👍

[@rahulbadhe5930]

nice session sir,, thank you so much.

[@SivaAcademy]

@Rahul, Welcome, sure, will be starting performance videos, due to my personal work, its getting delayed, however, i will definitely will try to start the new series on performance soon, please stay tuned.

[@mathankumar2228]

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

[@SivaAcademy]

Yes perfectly correct 👍👍

[@lakshmanakumart2228]

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

[@SivaAcademy]

I am not sure about version compatibility between dB and forms

[@pavankumar3597]

hi sir please make full video on dbms_monitor package , how to use it , what is advantage off it and how to call it

[@SivaAcademy]

Sure Pavan, Please stay tuned.

[@vinayakavini5334]

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

[@rabishankarbhagat2558]

Excellent explanation sir

[@SivaAcademy]

Welcome bro 💐

[@nileshdivate1]

Hi..But index will start from 0 in collection

[@gurumoorthysivakolunthu9878]

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 ...?

[@ankitvarshney15]

I think, it is getting closed in Python code... cur.close()

[@shaheenshaikh6701]

Record bhi hai na sir to hold more than 1 value

[@SivaAcademy]

@Shaheen, yeah, however record cannot hold more than one row...

[@padmapriya1262]

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

[@SivaAcademy]

Sure please stay tuned

[@jagadishdogga4886]

Sir need difference between ref cursor and collections

[@SivaAcademy]

@Jagasidh, I have covered little but the same video series, however, i will post explicitly on the difference between cursor and collection soon, please stay tuned.

[@WorldEye88]

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

[@SivaAcademy]

Not always... Depends on data

[@WorldEye88]

Thank you.

[@sridhartamilselvan]

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

[@SivaAcademy]

@Sridhar, Its my pleasure.. :-)

[@rahulbadhe5930]

sir make videos of performance tuning...

[@SivaAcademy]

@Rahul, sure...sorry for the delay..

[@priyankadesai9848]

Thank u for this video

[@SivaAcademy]

My pleasure

[@kdeepika6482]

Wonderful sir ur

[@SivaAcademy]

Thank you

[@manishsahu2740]

Very Nice learning through ur video. Thums up!

[@SivaAcademy]

Thank you 🙏

[@keerthin9362]

Hi sir, Could you please explain when to use which type of collection in Oracle with examples?

[@SivaAcademy]

Please look into this video, kzbin.info/www/bejne/imaqpmWbltZmZ80