Lida Gholizadeh

In Oracle 23c you can  store and query GeoJSON directly  without conversion between  JSON/GeoJSON and SDO_GEOMETRY. Oracle 23c also ensures  better compatibility  with GIS applications like PostGIS, ArcGIS, QGIS and web-based mapping tools. In the previous version,you should manually convert  GeoJSON to  SDO_GEOMETRY for inserting, and when you had a query  required extracting  SDO_GEOMETRY  and manually converting it back to GeoJSON. For example in Oracle 19c : 📙For Insert GeoJSON Data, you should  First  Convert it to  SDO_GEOMETRY   INSERT INTO My_Geospatial_Table (id, geom) VALUES ( 1, SDO_GEOMETRY( 2001, 4326, SDO_POINT_TYPE(-122.4194, 37.7749, NULL), NULL,  NULL ) ); 📘  And when you Query Data you should Convert it Back to GeoJSON   SELECT '{"type": "Point", "coordinates": [' || geom.sdo_point.x || ',' || geom.sdo_point.y || ']}' AS geojson FROM...

  If you did not install Oracle database 23ai and Apex24.2 you can first use the below link to install them and then back here to install and config ORDS. How we can Install APEX 24.2 and Oracle Database 23ai on Windows Step by Step: https://lidagholizadeh.blogspot.com/2025/03/install-oracle-database-23ai-and-apex.html 👀 Watch The below video in my YouTube channel about   Installation of Oracle Database 23ai and APEX 24.2 on Windows Step-by-Step  Why Do We Need ORDS for APEX? Oracle ORDS (Oracle REST Data Services) is a middle-tier application that enables RESTful web services for Oracle databases. It is essential for running Oracle APEX (Application Express) because APEX is a web-based application development platform that needs a web server to handle HTTP requests.We need it because APEX does not include a built-in web server.  It acts as a bridge between an Oracle Database and web applications, allowing developers to expose database objects  as RE...

👀 Watch The below video in my YouTube channel about   Installation of Oracle Database 23ai and APEX 24.2 on Windows Step-by-Step  ✅ Before starting check the System Requirements: Operating System: Windows 10-11 or  Windows Server 19-22 Memory: At least 4 GB RAM (8 GB or more recommended). Disk Space: At least 20 GB of free space. Administrator Access: You need administrative privileges to install software.   Install  Oracle Database 23ai on Windows: 👀I suggest you watch this video on my YouTube channel about this article my_video step1: Download  Oracle Database 23ai from below Link https://www.oracle.com/database/free/get-started/ you can also see the Installation Guide for Microsoft Windows: https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinw/index.html step 2: after unzipping downloaded files then click setup.exe step 3: This is mandatory to have at least one pluggable database in this step oracle start to configure LISTE...