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