New Features 23c: BOOLEAN Column Data Type

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.

Check Insert example:

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).

Enjoy this new features with 23c.

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply