Join us for the next **Oracle Beer Bern** meetup as we dive into **Oracle Database 26ai** and what it means for developers. We’re excited to welcome **Connor McDonald** **o

TL;DR: Some Very Simple tests of Assertions. Of course I want to know if it has any impact and maybe want to look a little bit closer or ev...

TL;DR: The DBCA showed me how to add catalog, catproc, and various components. We are Getting Somewhere. I'll try to make those scripts more...

TL;DR: Still on my quest to Create an Oracle 26ai Database From Scripts. I'll examine some of the resulting scripts from DBCA. Image: Critic...

TL;DR: I've got generated scripts from DBCA (see previous blogs) , and I experiment with them. First I morf the initial Create-statement an...

Learn how to Securely Generate Vector Embeddings from within Oracle AI Database 26ai using a local Ollama server

TL;DR: I want Scripts. Hence I am going to try and create an Oracle 26ai database purely using scripts. Specifically not recovering any temp...

Learn how to install Oracle DBMS_CLOUD into an Oracle AI Database 26a database and test website access with the Oracle UTL_HTTP package

Learn how to configure and test secure certificate based access to the Oracle Private AI Services Container.

TL;DR: The scripts generated by DBCA work, although some tweaks and caveats apply. But in the end: Yes. They Work! image: Startup of the DBC...

Learn how to Securely Generate Vector Embeddings from within the Oracle AI Database 26ai using the Oracle Private AI Services Container

How does the new Oracle 26ai REST API affect spatial data access? Developers can now use web tools to manage satellite images and maps without complex code.

Learn how to Configure Oracle AI Database 26ai Access Control Lists (ACLs) and test connectivity to the Oracle Private AI Services Container

TL;DR: The One Script you will Ever Need to create an Oracle 26ai Database . And for you to configure, should you want to. After a remark fr...

There are several ways you can calculate distances to determine how similar, or not, two vectors are. I'll introduce you each metric available in Oracle 26ai. Euclidean and Euclidean Squared Distances Computed using straight-line distance between two vectors. This is calculated using the Pythagorean theorem (SQRT(SUM((xi-yi)2))). Euclidean Squared avoid the square-root calculation, so, it's faster to compute. Cosine Similarity Measures the cosine of the angle between two vectors.

There is one main function to calculate the distance between vectors: VECTOR_DISTANCE. It takes two mandatory parameters, the two vectors to compare, and one optional paramenter, the metric. Let's start with some examples: SQL> CREATE TABLE vectotab(id NUMBER, vec_emb VECTOR); INSERT INTO vectotab VALUES(1,''); INSERT INTO vectotab VALUES(2,''); INSERT INTO vectotab VALUES(3,''); INSERT INTO vectotab VALUES(4,''); INSERT INTO vectotab VALUES(5,''); COMMIT; Table created.

A closer look at Oracle 26ai JOIN TO ONE: what the new syntax promises, how it works under the hood, and what it means for data warehouses.

Lo último en bases de datos: de almacenar información a comprenderla La evolución de las bases de datos está entrando en una nueva etapa. El objetivo ya no es únicamente almacenar grandes volúmenes d...

Las bases de datos están entrando en una nueva era impulsada por la inteligencia artificial Durante décadas, las bases de datos se diseñaron para almacenar, organizar y consultar información estructu...

500 million+ members | Manage your professional identity. Build and engage with your professional network. Access knowledge, insights and opportunities.