Posts

Showing posts from July, 2025

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...

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...