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

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

[mkr]

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

[mollamainuddin]

thank you very much, spacially for the last example;

[satvinderbhangu]

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

[dattatrayarathi]

Thank you for sharing the video in details.

[mlipina]

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 .

[kattelakarim]

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!

[SatyendraSingh-uliq]

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

[guhananbalagan]

Hi Siva could you please share your idea about cursor expression

[vikasmishra]

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

[SujitKumar-wgsz]

How to capture cursor column value in exception section

[SreenivasBORRA-kxhb]

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

[jithendrareddyambati]

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

[akshaybhong]

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

[dineshkumar-vpdm]

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

[dineshkumar-vpdm]

What difference between the for and forall clause

[abhilashk]

Please mention sys ref cursor.. thanks..

[durgakumarsunkara]

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

[antonybabu]

Sir! How can i write plsql programs for flames concept

[slyroy]

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

[yugandhartammineni]

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