PL/SQL tutorial 74: PL/SQL Bulk Collect Clause with FETCH-INTO statement of an explicit cursor presents a PL/SQL tutorial on how to use PL/SQL Bulk Collect with Fetch-Into statement of an explicit cursor in Oracle Database. Watch and learn how to enhance query performance with Bulk Collect in Oracle Database by Manish Sharma.


Previous Tutorial
► Introduction to Bulk Collect:
► Explicit Cursor:
► Simple Loop:
► The script on GIT:
►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 of Manish Sharma___

___Facebook Official Page of RebellionRider.com___

For E-mail address please check the 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


Akash Dey says:

HI Mahish, Thanks for your nice tutorial. But is that required to create the outer loop ?? As per my understanding, if we are using bulk collect then automatically entire set of rows will be fetched( bulk collected) into PLSQL table variable ? Please correct me

Shashank Dasaniya says:

Hello sir …where we can find videos later than no. 74?

anil mohanty says:

Manish using 1..collection. Count gives all the record on the same way can I use collection. First.. Collection. Last to get all the record if yes what is the diff

Nikhil Khare says:

Why did you put Fetch statment inside the LOOP??? I kept it outside of loop, means w/o the loop, still working the same as when kept inside.

Ganesh Gupta says:

one silly clarification needed,
since bulk collect will combine all the records in single chunk only, so why you have used Loop here. that first loop will always be execute only 1 time. ryte?

siddharth chaudhary says:

sir, can you please tell how much videos are left for uploading so we can have a better idea of the things remaining.
thank you,
videos are awesome.

Maha Sridhar says:

Thank you so much for the videos. I am starting my career as database developer and I find your videos highly useful.

Laxminath Dewangan says:

Hi Manish sir, For printing when I write the ‘FOR’ statement after closing the cursor , its getting compiled but no output is coming . could you plz help me to understand. Thanks

Grs Raja says:

Great Sir… could you please provide a video for disadvantage of bulk collect

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   Rims & Tires   Luxury BoatsFashion   Sunglasses   Luxury Watches   Luxury Purses   Jeans Wear   High Heels   Perfumes   Jewellery   Cosmetics   Shaving Helpers   Fashion HatsFooding   Chef Club   Fooding Helpers   Coktails & LiquorsSports   Sport Shoes   Fitness & Detox   Golf Gear   Racquets   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   Printers   USB Devices   PC Hardware   Network Gear   Cloud Servers   Software Helpers   Programmer Helpers   Mobile Apps   Hearing AidsHome   Home Furniture   Home Appliances   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