As new features within Oracle Database 23c, we can create tables with column data type BOOLEAN, also we can specify 0, or False as false and 1 or true as True.
![](https://wadhahdaouehi.tn/wp-content/uploads/2023/04/Screenshot-from-2023-04-17-03-35-43.png)
Check Insert example:
![](https://wadhahdaouehi.tn/wp-content/uploads/2023/04/Screenshot-from-2023-04-17-03-36-27.png)
ERROR: ORA-01790: expression must have same datatype as corresponding expression
With one statement, we cannot use 1 and true as true but we need to use 1 or true (Same for False).
![](https://wadhahdaouehi.tn/wp-content/uploads/2023/04/Screenshot-from-2023-04-17-03-39-00.png)
Enjoy this new features with 23c.