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
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..
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??
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.
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 .
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
Most underrated video ❤️great job
Glad you think so!
You are GOD of Oracle
Thanks you did help me . I have questions could tell me how to create procedure using cursor with using nested table array.
I have also same doubt
Implicit cursor is a pointer to a memory location maintained and managed by sql or plsql engine .
Thank you for sharing the video in details.
Welcome bro
Siva, Thank you again.
Sujaa
Welcome 🙏🙏 thanks for all your comments 🙏🙏
Very clear cut information 👍👍
Thank you
Explained very well. Thank you
You are welcome!
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..
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??
Very nice explanation ,thank you
Thank you
Hi sir, no need of writing extend() here when storing the values in collection variable from select statement?
Hi Siva , could you please ans this question
thank you very much, spacially for the last example;
You are welcome!
Sir please make some videos on oracle forms also...will get better understanding ...because the you way teach is very good...
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.
@@SivaAcademy okay sir ...
I mailed you to sir about topics please check mail sir..
How to capture cursor column value in exception section
Sir really excellent explanation..
Welcome 🙏
good and nice video
Thank you Sudarshan 👍💐
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 .
@Lipina, Sure, i will post as part of performance related videos.Please stay tuned.
Hi Siva could you please share your idea about cursor expression
Thanks A lot SIr ..:)
Welcome bro
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!
Awesome explanation sir
Thank you so much :-)
Thanks a lot
Sir! How can i write plsql programs for flames concept
Thanks shiva. Can we increase cursor memory in run time of cursor
Hi sir ...
(Cursors) Can we use more that one column in select statement?
Yes you can use
Can you please explain unix commands as well
Sure, please stay tuned
, waiting for itvshiva I am the production support engineer
Getting PLS-00394 : wrong number of values INTO list of fetch statement error
Excellent
@ganesh, thanks bro 🙏
Sir meru full course ki money entha
What is difference between normal procedure and standard procedure
pls share answer
Please mention sys ref cursor.. thanks..
What difference between the for and forall clause
nice explanation sir really ,more examples of bulk collect uses with some real examples upload sir...
@durgakumar, Thank you 🙏... Sure, will be starting PLSQL performance tuning soon, will post as part of tuning video series.
Tq sir,can you provide another video's about defferable ,non defferable and initiall y defferable .
Superb...
Thank you :-)
please clear cluster index and non cluster index use in plsql?
Sure, Please stay tuned.
Helpful
Thanks
Super..
@GOBI, Thanks for your comments 🙏🙏
Sir, what is the difference between a cursor and select * statement?
Technical both are same,one will get executed as implict cursor and another one is explicit cursor
Please explain cluster index and non cluster index
Sure, will post on cluster and non cluster index.