PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma

3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy
------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial
-------------------------------------------------------------------------
►►►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

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[maga_nov]

This guy is answering all my questions. Thanks for your tutorials.

[mohammadazaruddinjakkali]

Hi 'MANISH' 'AZAR' here... Thank you very much for providing a structured flow of tutorials, i am enjoying a lot and learning new things... I have a request for you, can you please make some example on CONDITIONAL STATEMENTS with more statements within a loop..

[rachna]

plz explain function, cursor topics as well.. in b/w i like how u teach.. really make me understand.. Thanks for nice tutorials..

[pradeepkamble]

Another underrated teacher...♥️ can you make a video on functions in Oracle

[keithkaishi]

Easy to understand, deserves subscription and likes

[canadadiaries]

very nice way of teaching...:)...Request you to please upload detail video on datatypes in PL/SQL.

[TechnicalwithAmit]

my one question
q- first we have to create two table
1.pass table
2.fail table
then the proram is that if salary is >10000 then the name pass table m chala jaye and agar < hai toh uska name fail m chla jaye
plzzz kaise hoga

[hamdaouimohamedzakaria]

THANKS MANISH VERY USEFULL LIKE USUALLY

[manishsemwal]

Can you do-
if(num%2==0) then
dbms_output.put_line(num||' is even');
else
dbms_output.put_line(num||' is odd');
end if;

[yuvaraj-kmod]

'&' is not working for me. any idea or any other options available?

error:
ORA-06550: line 2, column 17:
PLS-00103: Encountered the symbol "&" when expecting one of the following:

( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively

[haritmakwana]

why your code is not working on live oracle sql???

[triptichoudhary]

don't we need to define the data width of NUMBER type variable while declaration..??

[csabasomogyi]

&enter_a_number doesn't work for me.
ORA-06550: line 2, column 18:
PLS-00103: Encountered the symbol "&" when expecting one of the following:
( - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue avg count current exists max min prior sql stddev
sum variance execute forall merge time timestamp interval
date <a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specif

1. DECLARE
2. v_num NUMBER := &enter_a_number;
3. BEGIN
4. IF MOD (v_num, 2) = 0 THEN

[anchal]

sir ap be Jo link provide ki
hai that's not opening..what should I do?

[hemukalyandurga]

Buddy can you do videos on cursors and collections.. Like the way you present things.. Its really easy to understand

[Deepakgupta-eyfc]

What can I install for learn plsql programs

[bhargavasai]

1.Can you please provide me the logic to check whether the given number is a prime number or not, by passing an input using &Enter_a_value?
2.Can you please provide me logic to get the prime numbers in between two numbers by passing the inputs as &Enter_first_value and &Enter_second_value without using loops concept?

[saratkumarkedarisetty]

by useing if then else i want to update marks in a table....

[vermakaran]

Manish... pls make these videos in Hindi also.. 🙏🙏

[puneetbhardwaj]

Check the no is prime number or not a prime number