Apex

Foursquare open sourced over 104 million points of interest (POIs) collected over several years. This is a large dataset perfect for testing and learning more about Spatial in the database. Oracle APEX has what you need to explore and display these places in your own browser. Meet Foursquare OS Places Foursquare used to be very popular. People where checking in everywhere with their mobile phones. In November last year Foursquare made these POIs available for download. You can read more about the dataset here, and you can explore the places with Foursquare Studio where the graphics above is taken from. ...

This simple tip may help you troubleshooting integrations in APEX and ORDS. Show CGI Environment in APEX I have been struggling with integration issues in APEX lately. Listing out the CGI environment helped to identify the probable cause. Just create a region of type Dynamic Content and add this code: begin OWA_UTIL.PRINT_CGI_ENV; end; It will list values for HTTP_SERVER, HTTP_PORT, etc. If the configuration on your reverse proxy is wrong, it will likely show up here with values that will not work in the external world. ...

Every 4 months or so I need a simple way to split a string (VARCHAR2) into elements, where the elements are separated with some fixed value (a comma, a colon, or perhaps a longer string). Since my short-term memory is too short0, I figured I should make a reminder here. Of course, you’ll find this on Stackoverflow as well. There is this function in APEX, which is usually1 available for you in the database, even if you are not using APEX. Here is a short demo: ...