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.
————————————————————————
►►►LINKS◄◄◄
Blog : http://bit.ly/bind-variable
Previous Tutorial
► Constants in PL/SQL https://youtu.be/r1ypg7WH4GY
►User Variables :https://youtu.be/2MNmodawvnE
————————————————————————-
►►►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
Thanks
————————————————————————-
►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
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
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 RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Amazon Auto Links: No products found.
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)
Hi Manish,
Please tell me why my following code is not able to print the value of Bind Variable I have declared
VARIABLE var1 VARCHAR2(10);
EXEC :var2 := ‘HELLO’;
SET SERVEROUTPUT ON;
BEGIN
DBMS_OUTPUT.PUT_LINE(:var2);
END;
/
Thanks in advance…..
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.
for some reasons the exec and print statements are not working in my sql developer.The version is 4.1.3.20
thanks
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
i have seen all your videos, i’m waiting for more!
Thanks for all
sir you are doing a great job, please keep making these kinds of videos
Pretty Awesome.
i am getting error ” Missing IN or OUT parameter at Index :: 1 ”
I have a small doubt.., How to use bind variable in select statement when we are fetching multiple values from a table ??
Very useful tutorial.
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.
Sir, Can you please explain clearly about autoprint?
thanks a lot sir…
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!
Where should we write ” SET AUTOPRINT ON”??? in host environment or before the pl/sql block??
What is the use of bind variable in real world scenario ?