PL/SQL tutorial 10: PL/SQL IF THEN ELSIF Statement in Oracle Database by Manish Sharma
HTML-код
- Опубликовано: 4 фев 2025
- Watch and learn IF THEN ELSIF (ELSIF ladder)statement in PL/SQL by Manish Sharma RebellionRider.com
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : www.rebellionr...
Previous Tutorial
► IF-ELSE • PL/SQL tutorial 9: IF ...
►Simple Case: • SQL tutorial 49: CASE ...
►Searched Case: • SQL tutorial 50: CASE ...
►DECODE: • SQL tutorial 51: DECOD...
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►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
/ rebellionrider
/ imthebhardwaj
/ rebellionrider
plus.google.co...
/ mannbhardwaj
/ rebellionrider
/ 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
10 years ago this type of teaching 🔥🔥
Manish you are so cool. Thank you very much for your work. We appreciate the effort you put into making these tutorials.
+Bewildered Thank you so much for your encouraging words. They are truly a moral booster. always glad to be of help. Do keep watching and help others by sharing.
example rocks🔥✅
The level of content is too good
Manish your tutorial is very easy to understand.Thank you so much for the videos.Really appreciate your hard work in making these videos.It helped me a lot.
Thank you so much. Your appreciation really means a lot to me. Please do make sure to Like, Share and Subscribe. Thanks
Sir 😎 you are awesome
Your teaching tone is very easy to understand,
Thankyou sir ❤❤❤😊❤😊😊❤
That's the way of teaching! Awesome! Thanks for the interesting examples
Manish bhai....u have done great job... can't explain in words... 😀😀😀
Your video is just awesome. It's clear, precise and short. Thank you so much 🙏
love the way you describe brother
Manish, man you are teaching like a rockstar. awesome bro
Thanks for your BLOG, which really helps me a lot.
HI Manish you work so hard and i wish you the best in what ever you are doing . You are a genus. keep up the good work, thanks for sharing
Nice tutorials Manish sir......very easy to learn for beginners
Thank you, God may gives you long life which is full of happiness
Super like for avengers :D p.s. we admire ur teaching skills as well.. Thank you for ur videos they are helping alot. :)
Very good session for new learner..
Thank you so much for your appreciation. It means a lot to me.
Absolutely Awesome tutorial 🔥
Kya sikhata hai bhai laajawab
Best example ever manish
Nice video Manish. Truly helpful
BEST EXAMPLE EVER
very very cool! Thank you Manish!
Great Video! But the input works correctly if I use' &enter' instead of '&enter place' as input Amazon = Amazon place with the latter which is incorrect. I don't know if it has something to do with my version.
good sessions for beginners. Is there any videos on OBIEE
plz provide cursurs also
Great work! Thanks a lot!
good effort Sir!!!
Can you please Share the PL/SQL notes like as you explained in RUclips tutorials .
Kudos to you..
Is END IF mandatory or we can stop till ELSE; how to handle case sensitive input values. What if I give capital letter inputs
Dc and marvel example was hilarious 😂
I am a huge fan of Superman and Wonder women from DC side and Ironman and Kinch T'challa from Marvel side 🙂
you u got next level sarcasm
Sir nice explanation... Please share me overall link of control statements notes
thank you
Hi Manish,
Am following your videos, you are doing a great job buddy. Keep it up!
I have a question,
What if the user enter the input as 'amazon' instead of 'Amazon'' ??
Will both produce the same output or different ?
I know pl/sql is a case insensitive language but i am curious to know about my question....
Thanks in advance,
Syed Ghouse.
it's clear that u r a DC fan hh
just kidding nice course keep the the good work
Only for wonder woman and Superman 🤫. Thanks for the appreciation.😊
I like whe write the city Rio .. I am Brazilian!!
Made a tutorial on Case statement
IF v_place='Dholakpur' THEN
DBMS_OUTPUT.PUT_LINE('CITY IS PROTECTED BY CHOTA BHEEM');
What will be the syntax of this nested IF when a table is provided....like ive to write a conditional statements for the salary in the table....
N ya u do make sql interesting....thanks for these videos...😘
MAN YOU REALLY MAKE BORING PLSQL FUN
Error is showing on live.sql online platform... What to do? Not taking input from user
thnks
I hope Avengers come to my help in exam 😢😢😢
ha ha ha "plz call avengers"(good humour)
old:DECLARE
v_place varchar2(30):='&enter_place';
BEGIN
if v_place='Metropolis'then
dbms_outout.put_line('city is protected by Superman');
else if v_place='Gotman'then
dbms_output.put_line('city is protected by batman');
else if v_place='Amazon'then
dbms_output.Put_line('city is protected by wonder woman');
else
DBMS_OUTPUT.PUT_LINE('Please call Avengers');
end if;
DBMS_OUTPUT.PUT_LINE('Thanks for contacting us');
end ;
new:DECLARE
v_place varchar2(30):='Rio';
BEGIN
if v_place='Metropolis'then
dbms_outout.put_line('city is protected by Superman');
else if v_place='Gotman'then
dbms_output.put_line('city is protected by batman');
else if v_place='Amazon'then
dbms_output.Put_line('city is protected by wonder woman');
else
DBMS_OUTPUT.PUT_LINE('Please call Avengers');
end if;
DBMS_OUTPUT.PUT_LINE('Thanks for contacting us');
end ;
Error starting at line : 2 in command -
DECLARE
v_place varchar2(30):='&enter_place';
BEGIN
if v_place='Metropolis'then
dbms_outout.put_line('city is protected by Superman');
else if v_place='Gotman'then
dbms_output.put_line('city is protected by batman');
else if v_place='Amazon'then
dbms_output.Put_line('city is protected by wonder woman');
else
DBMS_OUTPUT.PUT_LINE('Please call Avengers');
end if;
DBMS_OUTPUT.PUT_LINE('Thanks for contacting us');
end ;
Error report -
ORA-06550: line 14, column 5:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
if
06550. 00000 - "line %s, column %s:
%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
🙏🙏🙏
set SERVEROUTPUT ON;
DECLARE
v_place varchar2(30):='&enter_place';
BEGIN
if v_place='Metropolis'then
dbms_outout.put_line('city is protected by Superman');
else if v_place='Gotman'then
dbms_output.put_line('city is protected by batman');
else if v_place='Amazon'then
dbms_output.Put_line('city is protected by wonder woman');
else
DBMS_OUTPUT.PUT_LINE('Please call Avengers');
end if;
DBMS_OUTPUT.PUT_LINE('Thanks for contacting us');
end ;
/
IF ELSEIF STATEMENT IS NOT GETTING OUTPUT.
PLEASE CHECK THE OUTPUT:
old:DECLARE
v_Place VARCHAR2(30) := '&Enter Place';
BEGIN
IF v_Place = 'Metropolis' THEN
DBMS_OUTPUT.PUT_LINE('This City Is Protected By Superman');
ELSIF v_Place = 'Gotham' THEN
DBMS_OUTPUT.PUT_LINE('This City is Protected By Batman');
ELSIF v_Place = 'Amazon' THEN
DBMS_OUTPUT.PUT_LINE('This City is protected by Wonder Woman');
ELSE
DBMS_OUTPUT.PUT_LINE('Please Call Avengers');
END IF;
DBMS_OUTPUT.PUT_LINE('Thanks For Contacting us');
END;
new:DECLARE
v_Place VARCHAR2(30) := 'Metropolis Place';
BEGIN
IF v_Place = 'Metropolis' THEN
DBMS_OUTPUT.PUT_LINE('This City Is Protected By Superman');
ELSIF v_Place = 'Gotham' THEN
DBMS_OUTPUT.PUT_LINE('This City is Protected By Batman');
ELSIF v_Place = 'Amazon' THEN
DBMS_OUTPUT.PUT_LINE('This City is protected by Wonder Woman');
ELSE
DBMS_OUTPUT.PUT_LINE('Please Call Avengers');
END IF;
DBMS_OUTPUT.PUT_LINE('Thanks For Contacting us');
END;
PL/SQL procedure successfully completed.
PLEASE HELP ME.
Metropolis Place is the input given so the output will be
Please Call Avengers
Thanks For Contacting us
If the input given was 'Metropolis' then the output will be
This City Is Protected By Superman
Thanks For Contacting us
set serveroutput on ;
Tickly Panda :please try this in single quotes in line 4.. I was also getting same error earlier
'&Enter_place_name'..
Hope this helps!
how to stop itteration on first occurance of vowel in a string
mystr:= 'sdfg sky to axe';
????
my o/p should be like
s d f g s k y t
Pls make vids in Hindi
I am planning on that