Oracle 23ai

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 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.9.0.25.07
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
0


-- the VECTOR type and AI vector search arrived in 23ai
create table emb (id number, e vector(3))
insert into emb
select 1, to_vector('[1,0,0]') from dual union all
select 2, to_vector('[0,1,0]') from dual

2 rows affected


select id
     , vector_distance(e, to_vector('[1,0,0]'), cosine) as cosine_distance
from emb order by id


ID
COSINE_DISTANCE


1
0

2
1.0E+000