Oracle databases have a boolean data type, but it is called "BOOLEAN" rather than "BOOL." The boolean data type can have only two possible values: true or false. You can use the "BOOLEAN" data type in SQL statements to define a column or a variable as a boolean type. Here's an example of how to create a table with a boolean column in Oracle:
CREATE TABLE mytable (
id NUMBER,
my_bool BOOLEAN
);
You can also use the "BOOLEAN" data type in PL/SQL blocks to define a variable as a boolean type. Here's an example of how to declare a boolean variable in a PL/SQL block:
DECLARE
my_bool BOOLEAN;
BEGIN
my_bool := TRUE;
-- Do something with the variable
END;
It's worth noting that Oracle supports several other data types that can be used to store boolean values, such as NUMBER(1), CHAR(1), or VARCHAR2(1), but BOOLEAN is the recommended data type.
0 Komentar