Oracle 26ai

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 AI Database 26ai Free Release 23.26.2.0.0 - Develop, Learn, and Run for Free
Oracle AI Database 26ai Free Release 23.26.2.0.0 - Develop, Learn, and Run for Free
Version 23.26.2.0.0
Oracle AI Database 26ai Free Release 23.26.2.0.0 - Develop, Learn, and Run for Free
0


-- 26ai is a release update of the 23 line (23.26), so this shows what
-- that line brought: AI vector search
create table emb (id number, e vector(3))
insert into emb
select 1, to_vector('[3,4,0]') from dual union all
select 2, to_vector('[0,1,0]') from dual

2 rows affected


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


ID
DIMS
NORM
COSINE_DISTANCE


1
3
5.0E+000
4.0000000000000002E-001

2
3
1.0E+000
1.0E+000