Home Oracle Commands Oracle Syntax PL /SQL
PL SQL Books
IF Statements

IF Statement Syntax:

   IF condition THEN
      statements;
   [ELSEIF condition THEN
      statements;]
   [ELSE
      statement;]
   END IF;


'condition' may include logical comparisons...

true AND true = true
true OR true = true

false AND false = false
false OR false = false

null AND null = null
null OR null = null

true AND false = false
true OR false = true

true AND null = null
true OR null = true

false AND null = false
false OR null = null

NOT TRUE = FALSE
NOT FALSE = TRUE
NOT NULL = NULL 
Related Commands:

Related Views:




Back to the Top

Simon Sheppard
SS64.com