Let us now consider certain examples where we will retrieve the rows of a particular table only when a certain logical condition evaluates to true. The execution of the above statement in PL/SQL is as shown below showing 1 when retrieved true Boolean value and 0 when retrieved false Boolean value. SELECT true, TRUE, True, false, FALSE, False For implementing this consider the following statement in PL/ SQL which has the output as 0s and 1s because true translates to 1 and false to 0. Let us consider a small example where we will try to retrieve different values or true and false Boolean values in small caps or in capitals or in any case. 1 value corresponds to TRUE value in Boolean while 0 is for FALSE value in PL/ SQL. The Boolean values are stored in the form of tiny int with one byte either 0 or 1 value in it. The Boolean datatype is not available in SQL, it’s only present in PL/SQL, and for SQL it is only present in oracle version 12cR1 and later versions.īoolean representation in PL/SQL queries – These conditions can also be used in where clause for constraint or restriction specification or even in the select clause while retrieving the values true or false depending on the fulfillment of the expression condition inside the values being retrieved in the select statement. The default value of the Boolean variable when not initialized is NULL.
Note that the Boolean variable specified here can also have a NULL value instead of TRUE or FALSE. Besides this variable declaration in Boolean datatype, the Boolean values are also used for comparing the values of columns with the Boolean value of true or false while retrieving the column values. When name of the variable is the variable name that we are going to declare as a Boolean data type variable.
0 kommentar(er)
