Oracle PL SQL interview question Explain REF Cursor Strongly Typed Ref Cursor and Weakly typed Ref C

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

% 1 446

Oracle PL SQL interview question Explain REF Cursor Strongly Typed Ref Cursor and Weakly typed Ref C
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

Наука

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

28 апр 2019

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Thank you so much sir. You teach with so much of clarity and examples, which is not available in other tutorial sites. I would have been lucky, if I had got an opportunity to watch these few years before itself. By chance, I started looking at your videos at least now. Thank God ! Those who are watching are blessed to hear you Sir! Vazhga Valamudan . Vazhga Nalamudan.

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

Its my pleasure to read this comment, thank you, வாழ்க வளமுடன் 🙏🙏🙏💐💐💐

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

Thank you very much for making so simple to understand. You know I'm following all your cursor videos.

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

Welcome bro 🙏 🙏🙏🙏🙏

@NaveenKumar-bi2ku 3 года назад

Very easy to understand. I was really struggling with ref cursors from a quite long time. Thanks for explaining so nicely.

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

Most welcome!

@AliBaba-mx8of 2 года назад

Thank you so much sir, for clear explanation.. I have lot of confused b/w ref cursor and parameterized cursor.. Now I got clear Idea ..

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

Thank you so much for the video ... It is so easy to understand in contrast to Oracle's own documentation which is sometimes really pain in the "lower back" -.-"

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

Glad it was helpful!, thank you for your comments

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

Sir you are just amazing..you have made a non technical person like me to understand and like such concepts

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

Its my pleasure to read this comment.... :-)

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

Thank You very much for the detailed explanation. Even a fresher can be able to master in PLSQL by watching your tutorials.

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

Welcome bro

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

Waaooww shiva Sir What a Explaination you r too Good....

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

Thank you so much shiva Academy. Your videos are easy to understand and useful .

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

Thank you

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

Thank You, sir...I am able to know the ref cursor with the help of this video. Before this, I was never able to understand the ref cursor concept.

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

My pleasure 🌸🌸🌸

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

I have watched all your previous videos for this section and all are very helpful ..thankyou so much for this good work.. I really appreciate it...

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

Thank you 💐

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

Great one, covered all the concepts revolving around Ref Cursor

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

Welcome bro 💐

@mr.b6101 2 года назад

Thanku Siva👍🏻 the best part is revision of the previous video which shows the vision of the author.

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

Welcome bro, thank you

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

Thanks for make it simply. Content is very good. Way of explain also great. Thanks.

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

My pleasure 🙏 thank you

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

thank u so much for the in-details explanation

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

Welcome 🙏

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

Thanks a lot...Excellent explanation... Now Understood all about ref cursor👍

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

Welcome 💐👍🙏

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

Thank you sir, for such a nice explaination

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

Welcome 🙏 🙏

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

This tutorial deserves much more likes. clear explanation..

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

Thank you

@swamivivekananda-cyclonicm8781 Год назад

Brilliant. You made it so easy.

@SivaAcademy Год назад

Thank you bro

@kumar-bi1to 2 года назад

Explained in detail. Thank you

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

You are welcome

@pprasanna541 5 месяцев назад

Your classes are so much usable

@SivaAcademy 5 месяцев назад

Thank you 🙏

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

Bcz of yur videos I got placed in top MNC thank u sir...hats off to your hard work

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

All the best

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

Thank u sir......hats off to yur work

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

Welcome 💐💐😊😊

@jishanshaikh5833 Месяц назад

Super Siva sir

@jubyaugustine6952 Год назад

Very useful content. Thanks a lot

@SivaAcademy Год назад

Welcome 🙏

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

Crystal Clear Explanation Sir..

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

Glad to hear that, thanks and welcome :-)

@vidyajagtap2783 Год назад

explained so well .. Thank you.

@SivaAcademy Год назад

Welcome

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

Best explanation for ref cursor ever.

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

Welcome bro 🌸

@monicabn3067 9 месяцев назад

Best sir ! The way you convey concept is amazing ❤

@SivaAcademy 9 месяцев назад

Thank you 💐🙏

@ramachandrans6349 5 лет назад

Really it is very helpful for me thank u

@SivaAcademy 5 лет назад

@Ramachandran, 🙏, Thanks for your comment :-)

@rahulbadhe5930 5 лет назад

thank you so much sir.. its very imp session.

@SivaAcademy 5 лет назад

@Rahuk, 🙏,It's my pleasure. Thanks for your comment :-)..... Happy Learning..Siva

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

Hi Shiva, Because of you'r videos i clear all the rounds in one of the MNC.. Thank you so much for posting the videos.. i am looking for Performance tunning related stuffs.. Please posted it will help for us.. Questions is: How to improve the query performance optimization Hints.. I have 10000 lines of code How to find out which line having the error..

@SivaAcademy 5 месяцев назад

My pleasure, thank you 🙏, please stay tuned. Will cover in upcoming videos

@achyutdeokatepatil897 5 лет назад

gerat knowledge . thanks a lot sir

@SivaAcademy 5 лет назад

@Achyut, thanks for your comments bro 🙏

@hemachannel9640 Год назад

Thanks a lot sir.. Very useful the whole OL SQL INterview questions. Can you please help us with performance tuning aspects as well..

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

Ur videos are really helpful n easy to learn 👍👍

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

My pleasure, thank you 💐

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

Thank you very much, it was clear and simple to understand. As requested earlier too, please make some videos for Advanced and expert level interviews. Regards, Sujaa

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

Sure will do, please post the topic you are looking for

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

Fabulous defination 🔥🔥🔥 thanks bro

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

My pleasure

@bapireddy209 5 лет назад

Thank you sir... it's very nice

@SivaAcademy 5 лет назад

@Bapi, Thanks 🙏 for your comment

@sureshkumar-eq4wb 3 года назад

Nice...your explanation is too good and easy to understand...

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

Thanks and welcome

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

Really helpful... Thanks

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

Welcome

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

Tq u so much my dear brother

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

Welcome bro 💐

@dattakor1548 5 лет назад

Wow... Thank u so much ✌✌✌✌✌

@SivaAcademy 5 лет назад

@datta, 🙏 I'm glad it helped, It's my pleasure. Thanks for your comment :-)..... Happy Learning..Siva

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

Nice one. Thanks

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

Welcome 💐

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

Excellent content

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

Thank you

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

Thank you for these very Informative and helpful video series with lot of clarity. Can you please post videos on performance tuning, query optimization, tkprof and sql trace.

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

Welcome, please stay tuned

@bapireddy209 5 лет назад

Concept is very clear..

@SivaAcademy 5 лет назад

@Bapi, Glad that it helped you :-) 🙏

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

Thankyou

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

Welcome

@aaashwini 5 лет назад

Thank you for the detailed explanation

@SivaAcademy 5 лет назад

Thanks Ashwini

@aaashwini 5 лет назад

In the video, it is mentioned we can return data using collections and ref cursors. Please give an example of usage of collection to return data.

@SivaAcademy 5 лет назад

@Ashwini, I have posted few examples on collection and ref cursor here, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-os1wkSkoK_w.html

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

@@SivaAcademy Thanks a lot ...Video on differences between collection and cursor is really helpful.. appreciate your help and detailed explanation in all your videos...

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

Welcome 🙏

@ganvwala5875 5 лет назад

❤❤

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

Excellent sir

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

THank you Sateesh

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

Very nice explanation sir

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

Thank you

@ArchnaVijay Год назад

All your videos are wonderful ..can you please make a video on performance tuning

@SivaAcademy Год назад

Sure, please stay tuned

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

super !

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

Welcome

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

Can we use a function returning ref cursor in an SQL query. If yes please let us know how to decode those columns and use in sql statement

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

🙌

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

🙏

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

Hi Sir.. This was very useful. Can you share a video on how to call procedures and functions.. various methods on how to call..

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

Sure I will, please stay tuned

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

We can use rowtype variable in named cursor also

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

Hi, Thanks for these valuable videos. i've got a question . I need to insert the records as batch. say i have 5000 records. i need to process it 1000 records at a time . and if any error occurs i need to skip the record and handle it in a exception where i will log the information. it would be helpful if you could explain best way to approach this scenario

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

Sir, very nice and simple explanations. I've one doubt, can we use multiple procedures within ref cursor. If yes, pls give 1 example. Thanks in advance.

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

Cursor is about holding the result of query, can you please eloborate your question with respect to procedure?

@hemanthkumar4741 2 месяца назад

How improve performance of ref cursor when we use insert query in it.

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

Another que is do we not need to close sysrefcursor type cursor ?

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

Sir, can you please tell me the difference among 3rd,4th and 5th points.

@lovehearts4437 8 месяцев назад

What do you mean by dynamically framed sql statements

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

nice video sir, still there one more clause in cursor called return?

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

Please Make a Vedios on Execute Immediate and Bulk Collect

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

@Vicky, sure bro, Please stay tuned.

@shifalig1796 Год назад

Please explain how to invoke shell script through Oracle

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

Need more examples for dynamic query and how it's act as a string here?? Can you please explain

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

Sure please stay tuned

@abinashdas12 5 лет назад

Sir pls make some video on performance tunning

@SivaAcademy 5 лет назад

@Abinash, Sure, will start posting tuning videos soon, please stay tuned.

@manojmeher866 5 лет назад

Sir pls make vdo on Bulk collect and Bulk Loading.

@SivaAcademy 5 лет назад

@Abinash, Sure bro....next video series is on performance tuning only...will be covering bulk concepts as part of that....please stay tuned.

@sridhartamilselvan 5 лет назад

Sir... Please add disadvantage also... Because ref cursor and sys_refcursor are rarely using in most of the projects comparing with explicit cursor. Then.. is any different between table%row_type and cursor%row_type? Because table%row_type usage also very rare comparing to cursor%row_type.

@SivaAcademy 5 лет назад

@Sridhar, Sure, I will post the advantage/disadvantage as part of next set of cursor video about difference between explicit cursor and ref cursor. Please stay tuned...

@sridhartamilselvan 5 лет назад

@@SivaAcademy Thanks for the reply sir...

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

Can you Elaborate about cursor return result to client api?

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

Sir please make video on Dbms_parallel_execute.

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

Sure bro, please stay tuned

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

Very good explantion sir..I have a question, what is the use of writing Sql statement in single quotes ,is there any differece if we put Sql statement without singles quotes?

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

Thank you... May i know where you are referring the single quotes? pls give an example

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

Open rc_emp_list_cur FOR 'SELECT deptno,dname From dept' In refcursor explantion

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

@@ankursrivastava5148 It considers as string value if you put inside quotes.

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

Can we call ref cursor as a reference cursor and why can u please tell.....me

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

Sir SYS_REFCURSOR can return number type Data or else only Varchar type Data? Please tell

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

sys_refcursor return based on the query associated to the cursor at run time.

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

Sir, can you please explain the difference between these two lines? i.e What happens when exit statement is placed before and after dms output package? How it works? Can you explain please. (1) exit when emp_name_list%notfound; dbms_output.put_line(v_name); (2) dbms_output.put_line(v_name); exit when emp_name_list%notfound;

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

both are same no difference....

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

Can you explain last two points with examples. Thanks

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

Last point I have covered with an example in video no 49

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

Hi Siva , if it is possible to fetch multiple table column in single cursor variable?

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

Yes its possible, curosr should have a valid select statement, it doesn't matter how many tables you are using in select statement, you can use 👍

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

@@SivaAcademy give me a example please

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

Eg, you can select all columns from emp and department tables joining both

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

It doesn't work, unable to fetch two tables column values in single cursor variable got an error --wrong number of values in the INTO list of a FETCH statement

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

Into clause also should have two variables to hold while you are trying to fetch into, number of variables in the into clause should match the number of columns you are trying to select

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

Sir, return type of strong ref cursor is always record data type..?

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

@RP, yes, the return type of strong ref cursor should either record type or table rowtype

@ramachandrans6349 5 лет назад

Hi sir Please make a video about dbms_profiler concept

@SivaAcademy 5 лет назад

@Ramachandran, i am about to post about this topic last week itself, got delayed due to some work.....mostly i will try to post by this week, please stay tuned.

@ramachandrans6349 5 лет назад

@@SivaAcademy thank u so much

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

Is Sys_RefCursor similar to ref cursor?

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

Not exactly, I have covered the difference in the subsequent videos

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

Is it possible to combine For cursor with Ref cursor? I'm getting this error 'RT_EMP is not a cursor'. Please let me where i went wrong. Thanks DECLARE TYPE REF_CUR_TYPE IS REF CURSOR ; RC_EMP_DEPT REF_CUR_TYPE ; /*REF CURSOR DECLARATION*/ RT_EMP EMPLOYEES%ROWTYPE; RT_DEPT DEPARTMENTS%ROWTYPE; BEGIN FOR i IN RT_EMP LOOP DBMS_OUTPUT.PUT_LINE(i.EMPLOYEE_NAME); END LOOP; END;