PL/SQL tutorial 27: How To Create An Explicit Cursor In Oracle Database By Manish Sharma

Learn How To Create An Explicit Database Cursor In Oracle with easy to understand example by Manish Sharma
Blog :
Previous Tutorial
► Introduction To Database Cursor –
► Simple Loop –
►►►Let’s Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.

►Make sure you SUBSCRIBE and be the 1st one to see my videos!
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

___Facebook Official Page___

You can also Email me at
for E-mail address please check About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

This is Manish from


Rahul Panda says:

Hi Manish… doubt it is awesome….if you can also upload a video related to the use of cursor I. e. why when to use it and it’s benefits…it would be wonderful…..thanks a lot… helps a lot….thanks again…

madhu bhardwaj says:

Sir, we can get the data in table by simply writing a select query then what is the advantage of creating cursor.

nagaraj b says:

Thanks for ur uploads expecting more videos on advanced topics like collections, bulk collect and PT.

Debajyoti Dutta says:

I like your style of presentation. Very catchy. Thanks!

Mohit Saxena says:

sir why there are 2 bruce in the output??
the exit when statement should be written after the fetch statement..

techprogrammer says:

thank u so much for oracle tutorial video………………

Pranav Srivastava says:

Could you please explain why your output returned ‘Bruce’ twice in your result?

santosh chary says:

hello Manish…if you write an example code for user handling exception with a wonderful example like which you have given in other sessions then that is also very useful for many….. :)

Kiran Kumar says:

Hi Manish, Thanks for the video.
Well I have one query, can you please tell me why is the Bruce record repeated twice ? In the Employee table, we have only one entry for bruce with id = 4.
Thanks in Advance :)

Pal Ayoub says:

Amazing tuto! I think, the exiting statement is better to be placed right after the FETCH statement so the last output ligne doesn’t get duplicated.

Asly Lee says:

plz upload form and reports in oracle

Amit Dey says:

The print statement will be after the exit condition, else the last row is getting printed twice. :)

Arun kumar Dachepalli says:

Sir, we can get the data in table by simply writing a select querry that you wrote then what is the advantage of creating cursor.

Asly Lee says:

yours tutorail is help me much more
thanxxxxx so much

Syed Ahad says:


Steve Egevski says:

i consider this like an array isn’t?

pankaj pandey says:

content and the way you present, both are awesome.

Simmlex says:

So… Why is this thing useful? You can achieve the same result with a simple 2 line SQL code.

uttam das says:

Hi Manish,
while i am trying to connect to the HR schema the below error is getting can you suggest me how to solve that?
“Invalid connection operation operation specified and verify the URL format for the specified driver”


Write a comment


Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Bicycles▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Kinis Swimwear▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Hiking & Trek Gear▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Audio HiFi▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Tools Workshop▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours