PL/SQL tutorial 26: Introduction to PL/SQL Cursor in Oracle Database By Manish Sharma

[@shaylaschroder7876]

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!

[@armandocastro2121]

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

[@raphaelrow8367]

itna ishtyle, i just loved watching this video.

[@adityaseth2410]

Superbbb!!👍🏻

[@souravkumarnanda2609]

This is so informative.. short and sweet

[@anusuyaperumal2155]

Thanks a lot, Manish

[@lovishgoel2745]

Well done manish bro

[@paragravka4209]

Amazing, your videos are very well strcutured and easy to understand.

[@RashedShaik-hp3be]

thqq bro ..u are time saver

[@harsimarsingh4918]

superb explaination.

[@saikatbanerjee9659]

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.

[@parag1702]

Super simple explanation!! loved it.. :)

[@Rebellionrider]

Glad you liked it 😊

[@VIP-very_insignificant_person]

Watching after 8 years and 4days

[@francischishimbe2058]

And I will pass

[@savarakumarkwaugh1741]

Thank you very much

[@sundarpandian787]

guruji you have done a wonderful job thank you

[@papachoudhary5482]

Great

[@aminharith1]

you so energetic sir

[@Rebellionrider]

Thank you so much

[@babithagirish1166]

cannot find the previous tutorial 25 on compound triggers.. could you please share the link

[@SKRT_DATA_MUSIC]

very nice bro

[@Rebellionrider]

Thank you so much

[@leewook4601]

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

[@kapiljain359]

Hey Manish.. great thanks for wonderfull videos..... i have a question regarding same topic........ why we use explicit cursor when we have implicit cursor?

[@francischishimbe2058]

I will

[@roshp5752]

Exelent Manish

[@Varsha_aesthetic_tuber]

Hi Manish, why should we go for cursors? Pls answer..

[@vishalsaxena5081]

i have a question Why stored procedure cant call from function ?

[@eMebyMonicaMateu]

Great teching^^thanks

[@Rebellionrider]

Thank you so much I am glad you enjoyed watching. Please consider subscribing to the channel.

[@saiabhilashputrevu2559]

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

[@bebosabir5016]

very nice

[@rameshthamizhselvan2458]

superb....

[@mdrehanyousuf]

good!!

[@maryamouhami]

thanks for the video, can you please tell me what s the difference between cursors , records and tables :=)

[@emanuelvald]

I'm questioning that same thing

[@rafdnaah6078]

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.

[@AntonPetersen93]

@@rafdnaah6078 Thanks a lot

[@ROSHAN-bp4qb]

an understandable subject

[@kapiljain359]

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

[@anisha7731]

You only teach oracle?

[@t.r.varsharadhakrishnan970]

Thank u sir

[@Rebellionrider]

Always a pleasure

[@itmaster4310]

good video

[@ani8530]

muy bien explicado :)

[@takashikovacs9877]

Hi Manish, I have a question.. in case of delete no action foreign key option, how to delete records of the primary key??

[@alalitha7973]

can u please share the details of oracle certification

[@patyue5012]

Thank you for sharing your knowledge or expertise. (L)

[@soumyakantapradhan4212]

thanks

[@sunitadoke493]

please tell what is trigger ??

[@4evermejdi]

thank you alot

[@ashitoshthakur9402]

😀😀❣

[@Ganeshay-09]

sir please to a make videos on plsql question and answer for interview

[@meghagupta8433]

Isme data print kse hoga

[@rameshthamizhselvan2458]

PGA is the program global area

[@BeggarPerson]

Aj Exam Hai Oracle Ki🥴😔

[@Rebellionrider]

All the best.

[@BeggarPerson]

@@Rebellionrider OMG Thank You🥰🥰

[@PAWANKUMAR-qq7hw]

Sir implicit cursors bhi define kr do

[@EchoverseMindAI]

good rap song.

[@Anonymous_31036]

Rj Manish

[@Rebellionrider]

🤣🤣🤣 Thank you

[@GeethadhanuRahul]

Thank you bro iam fail ,hate you

[@Rebellionrider]

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

[@krishnavinod8734]

​@@Rebellionrideris ur plsql series enough bro for complete plsql course, is anything else we need to learn plz let me know

[@mdsaifuddin3028]

Any Carry fan???

[@krativerma8208]

Bhaiya Itna style kis baat ka...padhane pe focus karo😂😂😂 very annoying accent!!

[@Rebellionrider]

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

[@garry9330810749]

I thought PGA stands for Program Global Area

[@papachoudhary5482]

Thanks

[@SivaKumar-rv1nn]

Thankyou sir