Carsten Czarski 🤨
LightNews LightNews
banner
cczarski.bsky.social
Carsten Czarski 🤨
@cczarski.bsky.social
630 followers 110 following 26 posts
Architect on the Oracle APEX development team.

https://apex.oracle.com

APEX and … SQL, PL/SQL, JSON, Spatial, Search, REST, and so much more …
Posts Replies Media Videos
cczarski.bsky.social
Something indeed was not right with that - and this is where the SDO_UTIL.DENSIFY_GEOMETRY comes in very handy. We get a line, which actually represents the flight path ...

#oracledatabase #spatial #orclapex
Use SDO_UTIL.DENSIFY_GEOMETRY to get the actual shortest path between two coordinate pairs. select sdo_util.densify_geometry( sdo_geometry( 2002, 4326, null, sdo_elem_info_array(1,2,1), sdo_ordinate_array( 11.80, 48.36, -122.37, 37.62 ) ) ) as path from dual The actual flight path (shortest path) visualized on a map.
March 31, 2025 at 1:06 PM
cczarski.bsky.social
Want to visualize a flight path on an #orclapex map ...? Let's try with a simple query and have a look at the results ...

See what's not right here ...?
SQL Query for a flight path. select sdo_geometry( 2002, 4326, null, sdo_elem_info_array(1,2,1), sdo_ordinate_array( 11.80, 48.36, -122.37, 37.62 ) ) as path from dual Result of this query, rendered on a map. select sdo_geometry( 2002, 4326, null, sdo_elem_info_array(1,2,1), sdo_ordinate_array( 11.80, 48.36, -122.37, 37.62 ) ) as path from dual
March 31, 2025 at 10:52 AM
cczarski.bsky.social
Found it. This is indeed a bug in APEX ( 37257902 - FACETED SEARCH/SMART FILTERS: FACET COUNT ISSUE WHEN FACET WITH TIMESTAMP LTZ IS FILTERED )

However, super-simple workaround: Just change the data type of your TIMESTAMP facet to DATE, then things will start to work. And no functional difference.
Screen shot of setting the data type of a Facet in APEX to date. Navigate to the Facet in Page Designer, then to the Source section and switch the data type to "DATE".
February 14, 2025 at 10:18 AM
cczarski.bsky.social
Check out the new "Sample Vector Search" application from the APEX Gallery, and learn how to leverage Vector Search on Oracle Database 23ai in APEX applications.

#orclapex #oracledatabase #vector #ai
Screen shot of the APEX Gallery, with the Sample Vector Search App highlighted. Screen shot of the Sample Vector Search App. A Vector search is done using the German word "Weltraum", and it finds entries related to space, regardless of the language.
January 31, 2025 at 10:47 AM
cczarski.bsky.social
Did you submit your abstract already? Deadline is tomorrow, December 2nd.

apex.doag.org

#orclapex #apexconn25 @doagev.bsky.social
Submit your abstract for the APEX Connect conference. May 13-15, 2025.
December 1, 2024 at 2:00 PM
cczarski.bsky.social
... seen the usage of REGEXP_SUBSTR and CONNECT BY to tokenize strings with SQL - and guess what? Was way too slow.

So, here's a LiveSQL V2 script to compare a few approaches.
livesql.oracle.com/next/library...

JSON_TABLE or APEX_STRING are still my favorites!

#OracleDatabase #SQL
Live SQL V2 script to show how delimited strings can be tokenized in the Oracle Database. My favorites are: -- -- Alternative 1: Split with APEX_STRING.SPLIT -- select record_id, count(column_value) as token_cnt from tokens, apex_string.split( record_tokens, ':') group by record_id; -- -- Alternative 2: Split with JSON_TABLE -- select record_id, count(token) as token_cnt from tokens, json_table( '["' || replace( replace( replace( record_tokens, '\', '\\' ), '"', '\"' ), ':', '","' ) || '"]', '$[*]' columns (token varchar2(255) path '$' )) group by record_id;
November 26, 2024 at 2:43 PM
cczarski.bsky.social
"Low Code and AI" - in 15 minutes.

#DOAG2024
Session “low code and AI” at DOAG2024, 1pm, room “Riga"
November 20, 2024 at 11:43 AM
cczarski.bsky.social
Florian Graßhoff is talking about security aspects of APEX applications at DOAG 2024.

#DOAG2024 #orclapex
Florian Graßhoff auf der DOAG 2024.
November 20, 2024 at 8:15 AM
cczarski.bsky.social
#DOAG2024 starts tomorrow.

The APEX community will gather in the "Kopenhagen" room and we'll start at 11:00 am, with an overview on APEX 24.1 new features.

See you there?
APEX 24.1 New features session at DOAG 2024: Tuesday, November 19th, 11:00am in room "Kopenhagen". Presenter is Carsten Czarski. Logo DOAG 2024 "Konferenz und Ausstellung"
November 18, 2024 at 10:36 PM
cczarski.bsky.social
Did you know that you can use Oracle APEX to create reports, charts or other visualizations directly on CSV files on OCI object store?

Have a read.
blogs.oracle.com/apex/post/vi...

#orclapex #oci #rest
Screen Shot showing a file in an object store bucket. Screen shot of a CSV file Screen shot showing results of APEX REST Data Source discovery of the CSV file in OCI object store. Screen shot showing a chart based on the contents of a CSV file - using APEX REST Data Sources.
November 18, 2024 at 10:36 PM
cczarski.bsky.social
Happy Birthday, #orclapex!
Screen shot of a file (flow.sql) from the Oracle APEX installation archive which shows that the first line is code was written at August 4th, 1999.
November 18, 2024 at 10:36 PM
cczarski.bsky.social
APEX 23.2 finally brings Custom Background Maps to the APEX Map Region. Source your background maps using Vector or Raster Tile Servers, or from a WMS server.

Try this feature out on apex.oracle.com today.
Screen shots containing examples for custom map backgrounds for the APEX map region. One example shows a WMS map background, the other one a Vector Tile Layer background.
November 18, 2024 at 10:36 PM
cczarski.bsky.social
Did you know that you can use REST APIs in ORDS to export and import APEX applications? Once you have a current ORDS version installed, you can simply export APEX apps using HTTP GET, and import with PUT requests.

Read all about it here:
blogs.oracle.com/apex/post/or...

#orclapex #orclords #REST
November 18, 2024 at 10:36 PM
cczarski.bsky.social
Answered this one to a colleague today: How to correlate AJAX requests to "normal" page views in APEX_WORKSPACE_ACTIVITY_LOG? SQL and MATCH_RECOGNIZE to the rescue.

#orclapex #sql
Screen shot of the MATCH_RECOGNIZE query to correlate AJAX requests to an APEX page view.
November 18, 2024 at 10:36 PM