Oracle PL SQL interview question CURSOR Vs COLLECTION

Просмотров 55 тыс.

% 747

Oracle PL SQL interview question CURSOR Vs COLLECTION
sivakacademy.blogspot.com/2019/05/collection-vs-cursor.html
Click here to subscribe to my youtube channel ru-vid.com/show-UCBt6VrxAIb5jLh9HLDcdwtQ
Oracle Interview questions and Answers at ru-vid.com/group/PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm
Oracle 18C New features at ru-vid.com/group/PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW
Oracle 12C New features at ru-vid.com/group/PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx-
Oracle PLSQL records and collections at ru-vid.com/group/PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm

Наука

Опубликовано:

30 май 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 64

@arunrocketz 4 года назад

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

@SivaAcademy 4 года назад

It's my pleasure,Thank you

@gsraj511 2 года назад

Thanks Siva for your detailed explanation...

@SivaAcademy 2 года назад

My pleasure 😊

@zramzscinece_tech5310 4 года назад

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

@SivaAcademy 4 года назад

Thank you,Sure, Please stay tuned

@kunuturuaravindareddy5580 2 года назад

simply superb clear and easily understandable

@SivaAcademy 2 года назад

Thank you bro

@ravikhanna29 3 года назад

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.

@rahulbadhe5930 5 лет назад

nice session sir,, thank you so much.

@SivaAcademy 5 лет назад

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

@sridhartamilselvan 5 лет назад

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

@SivaAcademy 5 лет назад

@Sridhar, Its my pleasure.. :-)

@SreeramReddyB 4 года назад

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

@bhushanpalse516 2 года назад

Excellent Explanation...sir

@SivaAcademy 2 года назад

Welcome bro

@uditkumar-vg5hb 11 месяцев назад

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

@priyankadesai9848 3 года назад

Thank u for this video

@SivaAcademy 3 года назад

My pleasure

@rabishankarbhagat2558 3 года назад

Excellent explanation sir

@SivaAcademy 3 года назад

Welcome bro 💐

@manishsahu2740 4 года назад

Very Nice learning through ur video. Thums up!

@SivaAcademy 4 года назад

Thank you 🙏

@vineetadola1547 2 года назад

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

@kdeepika6482 3 года назад

Wonderful sir ur

@SivaAcademy 3 года назад

Thank you

@vinayakavini5334 3 года назад

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

@suchitapatil4525 3 года назад

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

@padmapriya1262 3 года назад

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

@SivaAcademy 3 года назад

Sure please stay tuned

@mathankumar2228 4 года назад

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 4 года назад

Yes perfectly correct 👍👍

@photomyste3279 4 года назад

Here why we don't use extend in nested array

@poojalonibarhanpure2212 2 года назад

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()

@WorldEye88 4 года назад

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

@SivaAcademy 4 года назад

Not always... Depends on data

@WorldEye88 4 года назад

Thank you.

@lakshmanakumart2228 5 лет назад

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

@SivaAcademy 5 лет назад

I am not sure about version compatibility between dB and forms

@radhachikkarangappa4132 3 года назад

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

@SivaAcademy 3 года назад

Sure please stay tuned

@priyankadesai9848 3 года назад

Please sir

@rahulbadhe5930 5 лет назад

sir make videos of performance tuning...

@SivaAcademy 5 лет назад

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

@pavankumar3597 4 года назад

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 4 года назад

Sure Pavan, Please stay tuned.

@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()

@mathankumar2228 4 года назад

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

@SivaAcademy 4 года назад

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 4 года назад

@@SivaAcademy ok thank you sir

@nileshdivate1 2 года назад

Hi..But index will start from 0 in collection

@srarts6990 3 года назад

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

@SivaAcademy 3 года назад

Yes you can

@srarts6990 3 года назад

@@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 3 года назад

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 👍

@jagadishdogga4886 4 года назад

Sir need difference between ref cursor and collections

@SivaAcademy 4 года назад

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