Oh wow... I stumbled onto this video, and very glad I did. This is EXACTLY what I was looking for, and I didn't have to sit through a bunch of things I didn't need. I just wanted to know what a cursor is and how it works so I can read through some code to create documentation of a procedure from our ETL process. Your energy held my attention, and I was grinning the whole time. This video is GOLD! I have shared a link to your channel to my coworkers, and have subscribed to your channel. Now I'm checking out RebellionRider. Excellent video! Thanks so much!
Thank you for practicing your English. I understood everything you said without having to second guess. It's a whole different learning experience when you don't have to process language. Subbed
Hi Manish, I like your tutorial very much, you make things easy for us. I request you to upload videos on oracle performance tuning, that will be a great help. Adance thank you from my behalf.
Thanks for sharing this video! How to return cursor type variable to the procedure.... like how to write out parameter of cursor type variable in procedure thanks in advance!!
Hey Manish.. great thanks for wonderfull videos..... i have a question regarding same topic........ why we use explicit cursor when we have implicit cursor?
what operation are there in oracle which is not possible without cursor/ref-cursor/sys_refcursor?? please make a video or write on your block in details for better understanding
When you execute a select statement within oracle, the database engine stores the results in a memory location and assign an address or pointer to this location. That address or pointer is called cursor. When you want to retrieve the data from this memory location, you specify the keyword FETCH and the cursor name which is the pointer/address from where the data is to be fetched. A record is a user defined composite data type within PL/SQL block which has one or more fields within it. In many respects, it resembles a table in the database except that it is only a user defined type within PL/SQL block for carrying stuff around. It is not stored as a heap table. Assuming that you wanted to fetch an entire employee record from the employee table in the hr schema into PL/SQL block and process it, you will need to define a data structure which has the same fields or structure as the employee table to be able to hold that employee record. It should have all the fields that the employee table has and must match them in data type. This structured type is called a record.
Hi Manish. The videos are excellent. I was wondering you can give some examples for implicit cursors because that seems to be an important question in perspective of a job interview
Sorry to hear you're struggling. I'm here to help! If there's a specific part you found challenging, let me know, and I'll do my best to assist. Learning can be tough, but I'm rooting for your success. 👍
I am sorry for the inconvenience. Accent nae pasand Aya to kisi or ka video dekh lo... Video bhi dekh lia concept bhi smmajh lia... or hate comment bhi kr diya... That is a true example of khaya piya kuch nae or glass thda bara ana...
Oh wow... I stumbled onto this video, and very glad I did. This is EXACTLY what I was looking for, and I didn't have to sit through a bunch of things I didn't need. I just wanted to know what a cursor is and how it works so I can read through some code to create documentation of a procedure from our ETL process. Your energy held my attention, and I was grinning the whole time. This video is GOLD! I have shared a link to your channel to my coworkers, and have subscribed to your channel. Now I'm checking out RebellionRider. Excellent video! Thanks so much!
Thank you for practicing your English. I understood everything you said without having to second guess. It's a whole different learning experience when you don't have to process language. Subbed
itna ishtyle, i just loved watching this video.
superb explaination.
Hi Manish, I like your tutorial very much, you make things easy for us. I request you to upload videos on oracle performance tuning, that will be a great help. Adance thank you from my behalf.
Amazing, your videos are very well strcutured and easy to understand.
Thanks a lot, Manish
Superbbb!!👍🏻
This is so informative.. short and sweet
Well done manish bro
cannot find the previous tutorial 25 on compound triggers.. could you please share the link
thqq bro ..u are time saver
Thanks for sharing this video!
How to return cursor type variable to the procedure.... like how to write out parameter of cursor type variable in procedure
thanks in advance!!
Hey Manish.. great thanks for wonderfull videos..... i have a question regarding same topic........ why we use explicit cursor when we have implicit cursor?
guruji you have done a wonderful job thank you
Hi Manish, why should we go for cursors? Pls answer..
Super simple explanation!! loved it.. :)
Glad you liked it 😊
Great
Thank you very much
you so energetic sir
Thank you so much
what operation are there in oracle which is not possible without cursor/ref-cursor/sys_refcursor?? please make a video or write on your block in details for better understanding
Hi Manish, I have a question..
in case of delete no action foreign key option, how to delete records of the primary key??
very nice bro
Thank you so much
thanks for the video, can you please tell me what s the difference between cursors , records and tables :=)
I'm questioning that same thing
When you execute a select statement within oracle, the database engine stores the results in a memory location and assign an address or pointer to this location. That address or pointer is called cursor. When you want to retrieve the data from this memory location, you specify the keyword FETCH and the cursor name which is the pointer/address from where the data is to be fetched.
A record is a user defined composite data type within PL/SQL block which has one or more fields within it. In many respects, it resembles a table in the database except that it is only a user defined type within PL/SQL block for carrying stuff around. It is not stored as a heap table. Assuming that you wanted to fetch an entire employee record from the employee table in the hr schema into PL/SQL block and process it, you will need to define a data structure which has the same fields or structure as the employee table to be able to hold that employee record. It should have all the fields that the employee table has and must match them in data type. This structured type is called a record.
@@rafdnaah6078 Thanks a lot
i have a question
Why stored procedure cant call from function ?
Hi Manish. The videos are excellent. I was wondering you can give some examples for implicit cursors because that seems to be an important question in perspective of a job interview
Thanks
Watching after 8 years and 4days
And I will pass
You only teach oracle?
Thankyou sir
can u please share the details of oracle certification
very nice
Exelent Manish
superb....
an understandable subject
good video
Thank you for sharing your knowledge or expertise. (L)
muy bien explicado :)
good!!
Great teching^^thanks
Thank you so much I am glad you enjoyed watching. Please consider subscribing to the channel.
sir please to a make videos on plsql question and answer for interview
please tell what is trigger ??
Sir implicit cursors bhi define kr do
thank you alot
I will
Isme data print kse hoga
Aj Exam Hai Oracle Ki🥴😔
All the best.
@@Rebellionrider OMG Thank You🥰🥰
😀😀❣
PGA is the program global area
good rap song.
Rj Manish
🤣🤣🤣 Thank you
Any Carry fan???
Thank you bro iam fail ,hate you
Sorry to hear you're struggling. I'm here to help! If there's a specific part you found challenging, let me know, and I'll do my best to assist. Learning can be tough, but I'm rooting for your success. 👍
@@Rebellionrideris ur plsql series enough bro for complete plsql course, is anything else we need to learn plz let me know
Bhaiya Itna style kis baat ka...padhane pe focus karo😂😂😂 very annoying accent!!
I am sorry for the inconvenience. Accent nae pasand Aya to kisi or ka video dekh lo... Video bhi dekh lia concept bhi smmajh lia... or hate comment bhi kr diya... That is a true example of khaya piya kuch nae or glass thda bara ana...
I thought PGA stands for Program Global Area
Thank u sir
Always a pleasure
thanks