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

preview_player
Показать описание
Oracle PL SQL interview question What is cursor and what are the types of cursor in oracle

Рекомендации по теме
Комментарии
Автор

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

mkr
Автор

thank you very much, spacially for the last example;

mollamainuddin
Автор

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

satvinderbhangu
Автор

Thank you for sharing the video in details.

dattatrayarathi
Автор

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 .

mlipina
Автор

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!

kattelakarim
Автор

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

SatyendraSingh-uliq
Автор

Hi Siva could you please share your idea about cursor expression

guhananbalagan
Автор

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

vikasmishra
Автор

How to capture cursor column value in exception section

SujitKumar-wgsz
Автор

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

SreenivasBORRA-kxhb
Автор

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

jithendrareddyambati
Автор

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

akshaybhong
Автор

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

dineshkumar-vpdm
Автор

What difference between the for and forall clause

dineshkumar-vpdm
Автор

Please mention sys ref cursor.. thanks..

abhilashk
Автор

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

durgakumarsunkara
Автор

Sir! How can i write plsql programs for flames concept

antonybabu
Автор

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

slyroy
Автор

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

yugandhartammineni