04 June 2024

Reading and writing files on Amazon S3 from Oracle Autonomous Database and PL/SQL

›
In our mixed cloud environment of AWS and Oracle Autonomous databases, sometimes it's necessary to move files/blobs between the database...
19 August 2022

Correctly sorting data containing accented characters (a.k.a. the Côte d'Ivoire and Türkiye issue)

›
This will be short and sweet.  Hopefully it will be useful to some of you, As you may or may not know, the country formerly known as Turkey ...
19 November 2021

How I got SQL Developer working on a new MacBook Pro (MacOS Monterey - M1 Pro)

›
Note: See updates 2021-11-23, 2022-02-17 and 2022-06-29 below concerning the use of GraalVM's JDK as an alternative to JDK 17. This is ...
4 comments:
30 August 2021

Autonomous DB "You have exceeded the maximum number of web service requests per workspace"

›
We recently had an experience on an Oracle Autonomous Database where our production instance started giving us lots of errors saying: ORA-20...
23 January 2021

Making XML tags dynamic in SQL and PL/SQL

›
While trying to produce XML using Oracle's native XML functions, I needed some of the XML tags to be dynamic.  To simplify and illustrat...
14 December 2020

›
Ensuring that XMLTYPE to JSON transformations create JSON arrays - even when there is only a single element. Recently, my colleagues and I w...
15 September 2020

Making SQL Developer's UI use your preferred language

›
Recently I was using Oracle's SQL Developer at a client site where all the virtual PCs were configured for a non-English language and my...
09 August 2019

3 ways to synchronize your Oracle Text indexes

›
One of my favourite features of the Oracle database is Oracle Text.  In this blog post I'll discuss different approaches to the synchro...
06 June 2019

Setting HTTP Response Status Code 301 (Moved Permanently) in APEX

›
This will be a short one.  As our public-facing applications age and new applications are developed to replace them, we often have the pro...
1 comment:
01 February 2019

Solving an issue regarding escaping substitution strings in Oracle APEX

›
In a recent dashboard-type application, I was using Google Charts for one of my dashboard regions.  This meant that I needed to place some ...
1 comment: