HomeОбразованиеRelated VideosMore From: Manish Sharma

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

848 ratings | 87506 views
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
Html code for embedding videos on your blog
Text Comments (27)
Dev Jani (16 days ago)
can we pass these variable as in out oarameter in stored procedure?
Maths_kamlesh (3 months ago)
Variable f_name varchar(10); Exec :f_name := 'Harry Potter'; Set Serveroutput on; Begin :f_name := 'Daenerys'; dbms_output.put_line(:f_name); End; / print :f_name; P2-0552: Bind Variable "f_name" is not declared. PL/SQL procedure successfully completed. I get an error. Need your help.
Praneeth Muragani (3 months ago)
what is the purpose of using bind variable?
anupam kumar tejaswi (4 months ago)
how to use bind variable in where clause. i am getting error: not all variables bound..
anupam kumar tejaswi (4 months ago)
this error i am getting only while selecting multiple values , when i am selecting single column with into clause this error is not coming.
tapanjeet roy (8 months ago)
thanks a lot sir...
Shashank Vishnoi (8 months ago)
Nice explanation, pls make a video on hints and nocopy hint?
nikitha gupta (8 months ago)
Sir, Can you please explain clearly about autoprint?
harman bawa (9 months ago)
thanks
Jane Sidlo (1 year ago)
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.
Abhijeet Maurya (1 year ago)
sir you are doing a great job, please keep making these kinds of videos
mihir kar (1 year ago)
I have a small doubt.., How to use bind variable in select statement when we are fetching multiple values from a table ??
ItsMyHobbyTime (1 year ago)
What is the use of  bind variable in real world scenario ?
Debajyoti Dutta (5 months ago)
Performance improvement, as query plan gets revisited in the SGA as it finds bind variable instead of literal
shruti Rajauria (1 year ago)
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)
Akshay Pillai (1 year ago)
Pretty Awesome.
Shafali Deora (1 year ago)
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
Akshay Pillai (1 year ago)
There are multiple reasons why this error has come up. Have you installed the database on your machine? Have you started the Database?
Daniel Komorowski (1 year ago)
Very useful tutorial.
tripti choudhary (1 year ago)
Where should we write " SET AUTOPRINT ON"??? in host environment or before the pl/sql block??
Siddhartha Penchala (1 year ago)
Pl/SQL Block...
Aakash Bidlan (2 years ago)
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.
raman0369 (2 years ago)
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.....
saumya ranjan swain (2 years ago)
you are trying to print var2 which has not declared before.you have declared var1 but trying to print var2.
lokesh devasani (2 years ago)
i am getting error '' Missing IN or OUT parameter at Index :: 1 ''
quipoy (2 years ago)
for some reasons the exec and print statements are not working in my sql developer.The version is 4.1.3.20
Jose Daniel (3 years ago)
i have seen all your videos, i'm waiting for more!  Thanks for all

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.