PL/SQL Boolean

The Oracle PL/SQL Boolean data type is a data type that can store two values: TRUE or FALSE.
The Boolean data type is often used in programming to store values that can only be one of two options, such as true or false.

Syntax

To declare a variable with the Boolean data type, you use the following syntax:

variable_name BOOLEAN;

Examples

For example, the following declaration creates a Boolean variable named is_admin that can store two values: TRUE or FALSE:

is_admin BOOLEAN;

When you assign a value to a Boolean variable, you can use the keywords TRUE or FALSE, or the numbers 1 or 0. For example:

is_admin := TRUE;
is_admin := FALSE;
is_admin := 1; -- same as TRUE
is_admin := 0; -- same as FALSE

The following example uses the Oracle PL/SQL Boolean data type:

DECLARE
is_admin BOOLEAN := TRUE;
BEGIN
IF is_admin = FALSE THEN
-- do something here
END IF; 
END; 

In the example above, the IF statement will only execute if the is_admin variable is FALSE. If the is_admin variable is TRUE, the IF statement will not be executed.

You can also use the Oracle PL/SQL Boolean data type in assignments and comparisons. The following example uses the Oracle PL/SQL Boolean data type in an assignment:

DECLARE
is_admin BOOLEAN := TRUE;
BEGIN
is_admin := FALSE; -- assignment
END;

In the example above, the is_admin variable is assigned the value FALSE.