Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;

BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID

Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
0

-- 23c Free added the BOOLEAN type
create table task (name varchar2(10), done boolean)
insert into task
select 'write', true  from dual union all
select 'ship',  false from dual

2 rows affected

select name, done from task order by name

NAME
DONE

ship
FALSE

write
TRUE

-- 23c also allows SELECT without FROM dual
select 1 + 1 as two

TWO

2