Oracle PL SQL interview question What is cursor and what are the types of cursor in oracle

[@vivektarab1959]

0:15 - What is a Cursor 1:36 - As Expected Scalar Variable is not able to, or not Capable of Holding more than 1 value 1:46 - But our Expectation is 2:47 - As you can see the code 3:12 - Details about Cursor 4:30 - Cursor is nothing but a memory location a pointer to a m/m location 4:39 - From an Interview Point of View, Cursor is nothing but a Pointer to a m/m location 5:11 - Any Cursor Statement is executed through Oracle Only 5:58 - There are few types of Named Cursor 8:06 - Explicit Cursors

[@jayasreetummala5123]

Most underrated video ❤️great job

[@SivaAcademy]

Glad you think so!

[@sampathkumar8392]

You are GOD of Oracle

[@satvinderbhangu361]

Thanks you did help me . I have questions could tell me how to create procedure using cursor with using nested table array.

[@sridharandavarapu2119]

I have also same doubt

[@dattatrayarathi1014]

Thank you for sharing the video in details.

[@SivaAcademy]

Welcome bro

[@mkr7345]

Implicit cursor is a pointer to a memory location maintained and managed by sql or plsql engine .

[@kumar-bi1to]

Explained very well. Thank you

[@SivaAcademy]

You are welcome!

[@sujaa1000]

Siva, Thank you again. Sujaa

[@SivaAcademy]

Welcome 🙏🙏 thanks for all your comments 🙏🙏

[@mollamainuddin6485]

thank you very much, spacially for the last example;

[@SivaAcademy]

You are welcome!

[@pasha6644]

Very clear cut information 👍👍

[@SivaAcademy]

Thank you

[@dn9416]

Very nice explanation ,thank you

[@SivaAcademy]

Thank you

[@mohitkumar1854]

Thanks A lot SIr ..:)

[@SivaAcademy]

Welcome bro

[@vikasmishra4296]

Please make a detailed video on how to load billion of records in Oracle table in most efficient way and check whether my data loaded successfully or not. Please explain different method .. Also explain load data from file like Excel. Also explain billion of record dml changes..

[@sudarsanr87]

good and nice video

[@SivaAcademy]

Thank you Sudarshan 👍💐

[@SujitKumar-wg7sz]

How to capture cursor column value in exception section

[@SnehaYadogi]

Thanks a lot

[@pulluriphani1185]

Sir really excellent explanation..

[@SivaAcademy]

Welcome 🙏

[@jithendrareddyambati3985]

Hi sir, no need of writing extend() here when storing the values in collection variable from select statement?

[@Karsh.y]

Hi Siva , could you please ans this question

[@akshaybhong2898]

Sir please make some videos on oracle forms also...will get better understanding ...because the you way teach is very good...

[@SivaAcademy]

Hi Akshay, I have not worked in forms and reports, however I am planning to post on oracle APEX, conceptually somewhat similar to forms and reports, please stay tuned.

[@akshaybhong2898]

@@SivaAcademy okay sir ... I mailed you to sir about topics please check mail sir..

[@guhananbalagan3779]

Hi Siva could you please share your idea about cursor expression

[@arunrocketz]

Awesome explanation sir

[@SivaAcademy]

Thank you so much :-)

[@dineshkumar-vp9dm]

What difference between the for and forall clause

[@kattelakarim9665]

Hi Sir! Can you please explain what is the benefits of with hold option in cursors Recently I got one interview question about it. Thank you!

[@mlipina5324]

Sir ! very nice explanation on cursor intro . please upload some more examples of bulk collect uses with some real examples , and the cases where we are switching to bulk collect and ref and sysref cursors .

[@SivaAcademy]

@Lipina, Sure, i will post as part of performance related videos.Please stay tuned.

[@SatyendraSingh-ul5iq]

Thanks shiva. Can we increase cursor memory in run time of cursor

[@bharathipandian45]

Can you please explain unix commands as well

[@SivaAcademy]

Sure, please stay tuned

[@bharathipandian45]

, waiting for itvshiva I am the production support engineer

[@abhilashk2534]

Please mention sys ref cursor.. thanks..

[@ganeshkamble2737]

Excellent

[@SivaAcademy]

@ganesh, thanks bro 🙏

[@dineshkumar-vp9dm]

What is difference between normal procedure and standard procedure pls share answer

[@durgakumarsunkara97]

nice explanation sir really ,more examples of bulk collect uses with some real examples upload sir...

[@SivaAcademy]

@durgakumar, Thank you 🙏... Sure, will be starting PLSQL performance tuning soon, will post as part of tuning video series.

[@durgakumarsunkara97]

Tq sir,can you provide another video's about defferable ,non defferable and initiall y defferable .

[@slyroy7562]

Hi sir ... (Cursors) Can we use more that one column in select statement?

[@SivaAcademy]

Yes you can use

[@dattakor1548]

Superb...

[@SivaAcademy]

Thank you :-)

[@antonybabu5205]

Sir! How can i write plsql programs for flames concept

[@SreenivasBORRA-kx3hb]

Hi sir I have recently faced a question that we need to write a cursor to calculate sum of salary without using SUM function. Could pls help on this question??

[@bmanikandan70]

set serveroutput on; declare cursor c1 is select ammount from amaz where ammount is not null; v1 amaz%rowtype; t1 c1%rowtype; r number; begin r:=0; open c1; loop fetch c1 into t1; exit when c1%notfound; r := r+t1.ammount; dbms_output.put_line(r); end loop; close c1; end;

[@gobirajendiran263]

Super..

[@SivaAcademy]

@GOBI, Thanks for your comments 🙏🙏

[@atul.thorat]

Helpful

[@SivaAcademy]

Thanks

[@yugandhartammineni1991]

Getting PLS-00394 : wrong number of values INTO list of fetch statement error

[@atul.thorat]

please clear cluster index and non cluster index use in plsql?

[@SivaAcademy]

Sure, Please stay tuned.

[@shumailasami2277]

Please explain cluster index and non cluster index

[@SivaAcademy]

Sure, will post on cluster and non cluster index.

[@Sri_Gayatri_1]

Sir meru full course ki money entha

[@tanushreechatterjee3766]

Sir, what is the difference between a cursor and select * statement?

[@SivaAcademy]

Technical both are same,one will get executed as implict cursor and another one is explicit cursor