Posts

Showing posts from June, 2025

Leveraging ONNX Models for AI Vector Search in Oracle Cloud Database 23ai

Image
Oracle 23ai supports ONNX LLM models.😘 In Oracle 23ai, one of the powerful features is  AI Vector Search , which enables semantic search on unstructured data such as text, images, and audio. Oracle supports using ONNX models to convert input data into dense vectors, which are then stored in  vector columns  for efficient similarity search. ❓ What is ONNX (Open Neural Network Exchange) ? It is an open format for representing machine learning and deep learning models. ❓ How Can we use ONNX model in Oracle Database? in the first step you should Import ONNX model in your Database. I am going to use Oracle Cloud and upload my ONNX model in the storage of my cloud. Step 1: Upload ONNX Model to Oracle Cloud Storage In Oracle Cloud storage>bucket Then Upload your onnx file you downloaded Step 2: Import the ONNX Model into Oracle Database Use the DBMS_VECTOR package to I mport the ONNX model: you need to create a credential and for this you need your username and password ...

Create a Database in Oracle Cloud and Connect to it by Using SQL*Plus and SQL Developer

Image
How to Create a Database in Oracle Cloud and Connect to it by Using SQL*Plus and SQL Developer ❓ πŸ‘€ In the video below on my YouTube Channelhttps://www.youtube.com/@LidaGholizadeh_ORACLE_GIS , you can see the steps of creating a Database in Oracle Cloud and connecting using SQL*Plus and SQL Developer  πŸ‘‰Create an Autonomous Database in Oracle Cloud Login to http://cloud.oracle.com/         2. Navigate to Oracle Autonomous Database then  Click Create Autonomous Database .       3. Click Create Autonomous Database .        4. Download and Extract the Wallet In your Autonomous DB details page, click DB Connection . Select Instance Wallet . Click Download Wallet (you’ll need to enter a password for the zip file). Extract the contents to a known location,  C:\Wallet .          ✹ 5. unzip zip file and in sqlnet.ora and  change Directory to your wallet location ✹  Change ...