Oracle PL SQL interview question Explain Parameterized Cursor and For Cursor

Oracle PL SQL interview question Explain Parameterized Cursor and For Cursor

[aliemam]

Excellent Channel
Best Regards from Egypt

[debimishra]

Excellent video.with the help of your video l completed one of my assignment today in the office using parameterized cursor and for update and where current of clause ..
CAN YOU PLEASE MAKE VIDEO ON MATERIALIZED VIEW AND ITS UTILITY DEEPLY SIR ..ALSO VARIOUS TYPES OF AND STYLES OF WRITING HIERARCHICAL QUERIES IN PL SQL AND SQL SIR

[funwithus]

Excellent Tutorial and very well explained really you are a rock in explaining. Thank You

[manojmeher]

Sir Your explanation is really awesome.Pls upload video on performance tuning and oracle architecuture in depth.

[SarathKumar-qldr]

Sir excellent explanation.
please put video for cursor using while loop also.

[sujaa]

Thank you again Siva
Can you please make videos for Experienced professionals and Expert level in a different series with real time scenarios. That would be greatly helpful for a section of your subscribers.
Regards,
Sujaa

[prabhanjaneyareddyinakollu]

Sir, your explanation is so good, can we pass multiple parameters through parameterized cursor ?

[ganeshkamble]

Excellent explanation sir thanks you too much

[durgakumarsunkara]

Sir Your explanation is really awesome.

[QhairunnisaSyed]

Hi Sir Thankyou for your excellent Videos. Im having one doubt here.. you have used only 2 dept ids what if there are more than 100 ids how do we use for cursor with parameters. As it would be difficult to give all dept ids individually

[ramasubramanian]

how can we convince anyone to use cursor instead of for loop? Interview question asked to me.

[tej]

HI Sir, how do i validate my passed parameter if my passing deptno is valid or no?

[vaijayanthijaya]

Hi,
Having a clarification...
If we are using parameterized cursor in for loop, don't we need to close the cursor??... Because here it looks the cursor not yet been closed.. Pls confirm this

[vikaskumar-qrtj]

Hi Siva can more than one argument can be passed to a prametrized cursor at a time for example i wnat to pass deptno 10 and 20 info in a single go is it possible here???Explanation was beautiful.

[dattakor]

Desperately waiting for ref cursor ✌✌✌✌✌

[madhurithakare]

Why are we using cursors, when we can fetch the record using other objects in sql? Real time use I want to know.

[ankitrastogi]

Hi, can u make tutorial on index organised table and oracle hints, how they work, specially parallel auto

[revathi]

We cant use cursor attribute in for cursor ??

[slyroy]

Hi sir...
Parameter cursor ...we can send to more than one value or not ??

[vanamalashilpa]

Please tell the difference between unique key and primary key