Boolean variables can be assigned either directly by using values TRUE, FALSE, or NULL or as the results of logical expressions : Boolean « PL SQL Data Types « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> declare
  2      v_b BOOLEAN:=false;
  3  begin
  4      v_b:=extract(year from sysdate)>2000;
  5      if v_b then
  6          DBMS_OUTPUT.put_line('21st Century!');
  7      end if;
  8  end;
  9  /
21st Century!

PL/SQL procedure successfully completed.

SQL>








21.13.Boolean
21.13.1.BOOLEAN
21.13.2.Boolean literals
21.13.3.Boolean variables can be assigned either directly by using values TRUE, FALSE, or NULL or as the results of logical expressions
21.13.4.How to assign a TRUE value to a variable of type boolean
21.13.5.Use BOOLEAN type variable
21.13.6.Use 'and' to connect two boolean expressions
21.13.7.Demonstrates the effects of NULLs on Boolean expressions
21.13.8.Boolean type parameter
21.13.9.Exit when a boolean conditioin
21.13.10.Logic operator and boolean value