Breaking News: Grepper is joining You.com. Read the official announcement!

plsql if statement

R Dyk answered on April 28, 2022 Popularity 9/10 Helpfulness 3/10

answer plsql if statement

related if else in plsql

plsql if statement

Comment

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

ELSIF condition2 THEN
   {statements when condition1 is FALSE and condition2 is TRUE...} ;
   --it would jump to END IF
ELSIF condition3 THEN
   {statements when condition1 ans 2 is FALSE and condition3 is TRUE..} ;
   --it would jump to END IF
ELSE
   {...statements to execute when it comes here...} ;

END IF;

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: if-statement plsql sql

Link to this answer
Share Copy Link

Contributed on Mar 19 2023

R Dyk

0 Answers Avg Quality 2/10

Closely Related Answers

if else in plsql

Comment

declare 
a integer := 30; 
b integer := 40; 
begin 
if (a>10) then 
dbms_output.put_line(' a is greater than b'); 
else 
dbms_output.put_line('a is greater than 10'); 
end if; 
dbms_output.put_line('value of a : ' || a); 
end;

Popularity 10/10 Helpfulness 5/10 Language sql

Source: livesql.oracle.com

Tags: plsql plsq

Link to this answer
Share Copy Link