pl sql if else

IF condition1 THEN
   {...statements to execute when condition1 is TRUE...}

ELSIF condition2 THEN
   {...statements to execute when condition1 is FALSE and condition2 is TRUE...}

ELSE
   {...statements to execute when both condition1 and condition2 are FALSE...}

END IF;

View another examples Add Own solution

Log in, to leave a comment

4.11

9

Awgiedawgie 440215 points

                                    DECLARE 
   a number(3) := 100; 
BEGIN 
   IF ( a = 10 ) THEN 
      dbms_output.put_line('Value of a is 10' ); 
   ELSIF ( a = 20 ) THEN 
      dbms_output.put_line('Value of a is 20' ); 
   ELSIF ( a = 30 ) THEN 
      dbms_output.put_line('Value of a is 30' ); 
   ELSE 
       dbms_output.put_line('None of the values is matching'); 
   END IF; 
   dbms_output.put_line('Exact value of a is: '|| a );  
END; 
/

Thank you! 9

4.11 (9 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

oracle plsql if else statement if condition in sql oracle query if statement plsql select statement if condition oracle if statement in oracle select in if statement oracle pl sql if else oracle oracle and if statement oracle if else if statement if statement in oracle sql query if else in trigger oracle if else plsql example if then plsql if else in oracle procedure oracle select with if if oracle select plsql if else example oracle plsql if else if else in pl sql IF ON ORACLE SQL SQL oracle else if if statement in oracle sql if else statement oracle select IF ELSE CONDTION ORACLE if else plsql oracle if else oracle sql query if condition plsql pl sql if statement and select statement with if condition in oracle pl sql conditional statements using if statements in oracle sql if else i oracle query plsql if else if else if plsql pl sql select if statement oracle function if else if else if PL sql IF AND ELSE IN ORACLE if else in oracle sql select query example ELSE IN PLSQL if else in pl sql function if else in pl sql oracle if else end if pl sql else if in pl sql pl/sql if statement oracle sql where if then else pl sql programs using if else plsql sql server if else if else function in oracle sql if statement with and oracle plsql if and else plsql is else pl sql exit if statement select if condition in oracle plsql if elseif if pl sql pl/sql if statement in select ORACLE PL/SQL IF ELSE EXAMPLE oracle if then else in select pl sql if with select statement if oracle sql oracle sql IF if-then-else in select statement oracle if statement in pl sql if else in plsql how to use if in pl sql oracle if statement in select pl sql procedure if then else example IF THEN ELSEIF in PLSQL if then else in plsql oracle sql if else in select oracle sql if else oracle 11 if else if then else oracle pl sql select into else IF SQL ORACLE else if and sql developer oracle oracle pls sql elseif if else in oracle sql if else in sql oracle if statement in select oracle if statement oracle else if in sql oracle select if else in oracle elseif oracle else if sql oracle Oracle sql if statement oracle case else if IF STATMENT ORACLE if else sql oracle oracle when else else if in oracle procedure else if and elsif in oracle oracle if else if oracle if else sql sql if then syntax oracle oracle if statement in where if else in oracle pl sql example pl sql else select if else oracle if else oracle' SQL ORACLE ELSE ELSEIF oracle pl/sql else if if else if else plsql pl/SQL LOOP IF ELSE if else in oracle sql query example if else oracle sql if statemenet sql oracle if statement sql oracle oracle if function in select if and else if pl sql oracle select if then else if in pl sql if else plsql elsif oracle plsql ELSIF oracle oracle if then if elseif oracle sp sql oracle if else if ELSE oracle pl sql orcale sql else if else plsql plsql if else if elsif plsql oracle if begin if then end if oracle if else if oracle plsql end if pl sql if then else not pl sql if then else is stamement example oracle oracle plsql else if pl sql if else if plsql if oracle if condition if oracle sql example plsql else if pl sql oracle if else if else in oracle function pl sql if else oracle if function IF Oracle if in a else pl sql if else if pl sql else if in plsql if pl sql oracle example if else oracle oracle pl sql if then else if statement if then if oracle oracle if condition example pl sql if statement plsql if then THEN AND ORACLE oracle else if pl sql if else if in oracle pl sql if elseif else else if oracle oracle pl/sql if if in oracle query if in oracle else if plsqls if procedure oracle if condition in oracle package else if oracle sql if else in oracle example ifelse in oracle oracle if eslse if if else if plsql pl sql else if oracle if statement ifelse in plsql sql if else oracle if else if end if oracle if pl sql oracle pl sql end if if condition in oracle elsif in oracle if else in oracle if then else plsql if the else plsql Oracle if else PL\SQL Else if ORACLE IF if plsql how to do a if condition in pl sql if then oracle IF ELSE PL SQL if then statements oracle

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example