PL/SQL tutorial 6: Bind Variable in PL/SQL By Manish Sharma

Watch and learn what are bind variables in PL/SQL how to declare or create them using Variable command, Initialize them using Execute (exec)command and different ways of displaying current values of a bind variable for example using AutoPrint parameter.

Blog :
Previous Tutorial
► Constants in PL/SQL
►User Variables :
►►►Let’s Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
►►►Help Me In Getting A Job◄◄◄

►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company

►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

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


shruti Rajauria says:

Thanks to explain the bind variable briefly!
please upload the video of ‘SUBSTITUTION VARIABLE” and difference of both type of variables(bind and substitution variable)

raman0369 says:

Hi Manish,

Please tell me why my following code is not able to print the value of Bind Variable I have declared

EXEC :var2 := ‘HELLO’;

Thanks in advance…..

Jane Sidlo says:

I hate PL SQL, working with variables is so convoluted. I just want to assign a variable and the run an SQL statement using that variable… seems PL SQL can’t do this.

quipoy says:

for some reasons the exec and print statements are not working in my sql developer.The version is

harman bawa says:


Shafali Deora says:

Hi, i m getting an error ora01017 invalid username and password while creating a new connection in oracle sql developer. I don’t know what userame and password do i need to put there to get rid of this error. Kindly suggest. Thanks

Jose Daniel says:

i have seen all your videos, i’m waiting for more! 

Thanks for all

Abhijeet Maurya says:

sir you are doing a great job, please keep making these kinds of videos

Akshay Pillai says:

Pretty Awesome.

lokesh devasani says:

i am getting error ” Missing IN or OUT parameter at Index :: 1 ”

mihir kar says:

I have a small doubt.., How to use bind variable in select statement when we are fetching multiple values from a table ??

Daniel Komorowski says:

Very useful tutorial.

Aakash Bidlan says:

hii !

when i want to take the value from user and run the program the program run. BUT the statement comes like “ENTER THE VALUE FOR a1” but
suppose i want to tell the user that “ENTER THE VALUE FOR RADIUS” than the value has been taken like in other languages how can i do so please tell me can we do this in pl/sql.

nikitha gupta says:

Sir, Can you please explain clearly about autoprint?

tapanjeet roy says:

thanks a lot sir…

Kevin Rambo says:

You are an awesome instructor. I love the way you get to the point quickly, directly, and clearly. Keep up the good work, and thanks for sharing your knowledge!

tripti choudhary says:

Where should we write ” SET AUTOPRINT ON”??? in host environment or before the pl/sql block??

ItsMyHobbyTime says:

What is the use of  bind variable in real world scenario ?

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