Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

BOOLEAN

The BOOLEAN datatype is used to store true/false values. Its range is only the two values, true and false. The Syntax for the BOOLEAN Datatype variable_name BOOLEAN; Here are some examples: hired_fired_same_day BOOLEAN; birthday_is_today BOOLEAN; print_this_record BOOLEAN; Boolean variables are often used as flag variables. Boolean variables are also used to store the results of logical calculations. For example, isTrue := (emp_birthdate = trunc(sysdate))