Posts

Intelligent Geospatial Application with Oracle Spatial AI and Oracle APEX

-
Image
In this article, I built a simple end-to-end spatial analytics application using  Oracle Spatial AI in Oracle Machine Learning for Python (OML4Py)  and then prepared the results for presentation in  Oracle APEX . The scenario I implemented is based on  grouping geographic areas by household income  and comparing two different clustering approaches: Traditional non-spatial clustering , where areas are grouped only by similar numeric values. Spatial clustering with regionalization , where areas are grouped not only by similar values, but also by geographic neighborhood relationships. The main idea behind this scenario is very practical. If I only cluster areas by income, I may get groups that are statistically similar but scattered across the map. But if I use spatial clustering, I can generate clusters that are both  income-similar  and  geographically coherent . This makes the results more meaningful for regional analysis, location intelligence, a...
Post a Comment
Read more

Oracle AI World Tour 2026 in FrankFURT

-
Image
I had the chance to attend the Oracle AI Cloud World Tour 2026, and it was an amazing experience👌💪💖 In this video,  I’m sharing some moments from the event, the atmosphere, around the Oracle AI World Tour 2026 in Frankfurt. Watch it 👀😉 The Oracle AI World Tour brings together developers, engineers, data professionals, architects, and tech enthusiasts to explore the latest innovations in Artificial Intelligence, cloud computing, and enterprise technology. It’s a great opportunity to learn about new tools, discover emerging trends, and connect with people who are working on similar technologies in the industry. Events like this are not just about presentations they’re also about the community. You can meet developers, exchange ideas, discuss realworld challenges, and see how different companies are using technology to solve complex problems. At the event, there were many interesting sessions about Oracle Cloud Infrastructure (OCI) , Generative AI , data platforms, and moder...
Post a Comment
Read more

How to Handle Nested JSON Arrays from REST APIs in Oracle APEX ITEMS

-
Image
One of the most common challenges when integrating external REST APIs with Oracle APEX is dealing with nested arrays of key value pairs. Instead of returning data in a flat JSON object with fixed properties, many APIs return a flexible array like this: {   "attributesList": [     {       "attributeName": "customer_id",       "attributeValue": "CUST-1001"     },     {       "attributeName": "account_number",       "attributeValue": "ACC-778899"     },     {       "attributeName": "order_reference",       "attributeValue": "ORD-2026-001"     },     {       "attributeName": "order_date",       "attributeValue": "2026-01-15"     }   ] } This structure is very flexible the API can add new attributes without changing the JSON schema but it requires special configuration in APEX to ex...
Post a Comment
Read more

Oracle APEX Developers Are Saying Goodbye to the Old RESTful Services

-
Image
  Imagine you're deep in your Oracle APEX workspace, happily clicking away in SQL Workshop to tweak a REST API endpoint. Suddenly, a big red DEPRECATED banner stares back at you like an old friend who's overstayed their welcome !!! If you're still building or maintaining RESTful Services directly inside APEX's SQL Workshop, you're not alone ,but Oracle made it clear starting with ORDS 25.1: the classic RESTful Services interface in APEX is officially deprecated😐 SQL Developer Web 👀 , that's now the single source of truth for managing ORDS REST APIs. 👉 Creating the RESTful Service in SQL Developer  Web STEP1: STEP2: In SQL Developer Web, navigate to the "REST" .it is in hamburger menu and you can find it in below picture now you are here .look at below picture isn't familiar with you? we have all RESTFUL Service features now at the top of the page STEP3: let's create a restful webservice. Click on Module in the top menu and fill the propert...
Post a Comment
Read more

Secure RESTful Web Service in Oracle APEX with Basic Authentication

-
Image
Heard they say you should secure your web service? 👮   Stick with me in this article, and I’ll show you a professional way to secure your RESTful Web Service with Basic Authentication   In the previous article, I explained how to CREATE  a RESTful Web Services inside Oracle APEX. https://lidagholizadeh.blogspot.com/2025/08/all-about-restful-webservice-in-oracle.html In this Article I will shows you how to build a professional, secure JSON RESTful web service in Oracle APEX that returns employee details from the HR.EMPLOYEES table, protected by Basic Authentication with PBKDF2 password hashing. Prerequisites Oracle Database 19c or later Oracle APEX 21.1 or newer HR sample schema unlocked and available EXECUTE on DBMS_CRYPTO A workspace with privileges to create RESTful Services 🚴 Let's GO Step 1 – Create a Table to Store Web Service Users CREATE TABLE ws_users ( username VARCHAR2 ( 100 ) PRIMARY KEY, password_hash VARCHAR2 ( 64 ) NOT NULL , -- ...
2 comments
Read more