Posts

Rendering HTML with/without PL/SQL in Oracle APEX (New Versions 24.X)

-
Image
  In older versions of Oracle APEX, developers often used the Region Type: PL/SQL Dynamic Content and wrote code with  htp.p   to directly print HTML to the page. However, in newer versions  APEX 23.2, 24.x , this region type has been deprecated . Oracle now recommends cleaner and safer methods to generate and display HTML, typically using templates and modern region types. 👉Render HTML in Oracle APEX: 1 .  Dynamic Content  (Recommended) 2.  Using htp.p in PL/SQL Processes ( Legacy ) , we should discuss it 😳 3.  Static Content Region 4.  Reports with HTML Expressions  Let's Go : 1 .  Dynamic Content (Recommended) Dynamic Content  with PL/SQL Function Returning HTML  This is the official replacement for the old Dynamic PL/SQL Content. After this section in section 2 ( Using htp.p in PL/SQL Processes ), I will discuss it. Example: declare l_html clob; begin l_html := '<h2 style="color:blue;">Hello Ora...
Post a Comment
Read more

Building an AI-Powered Resume Matching System Using Oracle APEX and 23ai Vector Search😎

-
Image
I am going to Develope an AI-powered Resume Match system using 23ai vector search in an Oracle APEX application to  to semantically compare project descriptions with personnel resumes. The system calculates and ranks the percentage of relevance between each project and candidate profile. During this process you will learn about Oracle AI Vector Search and Similarity Search   During this process, you'll gain hands-on experience with: Oracle AI Vector Search Semantic Similarity Search Integrating ONNX models Oracle APEX Interactive Reports and Charts 👀 In the video below on my YouTube  Channelhttps://www.youtube.com/@LidaGholizadeh_ORACLE_GIS , you can see the steps of Building an AI-Powered Resume Matching System Using Oracle APEX and 23ai Vector Search 🟎 Overview of Steps Before creating APEX app you need 2 steps as below : 1) Create an Oracle DB23ai on Oracle Cloud  Use Oracle Cloud Infrastructure (OCI) to create a 23ai-compatible Ora...
Post a Comment
Read more

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 ...
Post a Comment
Read more

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 ...
Post a Comment
Read more

Building a Fully Local AI-Powered Assistant with Oracle APEX and Vector Search #APEXCONN2025 #orclAPEX

-
Image
👩 : Falls Sie nicht müde sind  :-| 👨 : Ich bin immer müde, aber das ist okay :-) I recently attended the APEX Connect 2025 conference from Syntegris Company.  One of the presentations that strongly caught my attention focused on the development of a personal assistant powered by Artificial Intelligence (AI), which runs completely offline,  with no reliance on cloud services . This assistant was implemented using technologies such as Oracle Database 23ai , Vector Search , and the RAG (Retrieval-Augmented Generation) approach. It was designed to manage personal information, emails, calendar entries, and project data. 👀Watch this short Video about  #ApexConn2025    https://youtube.com/shorts/UQmwwTEsJuk?si=WJUXdJ4jvh1Nmsap The presenter highlighted the challenges of his life, such as: High volumes of daily emails  Multiple overlapping meetings Fragmented and scattered information He proposed a personal AI assistant that could : Filter emails and ext...
Post a Comment
Read more