Update: thanks to Connor McDonald for pointing out how to fix this issue (see "The Solution" and subsequent explanation below). Connor wrote a followup post based on this article discussing count(*) vs count(1) differences. The Problem I recently had...
The KEEP clause in Oracle
When dealing with Oracle SQL statements and the need to parse JSON arises, you've likely encountered the json_value function. However, Oracle offers a more straightforward approach through simple dot-notation access to JSON data. This feature can sim...
Well that's a loaded title! Most developers may not know what each term means and as such this article will break down each item then group it all together. apex_string.split apex_string.split allows you to split a delimited string into rows (similar...
In Oracle the listagg function is limited to 4000 characters. If the resulting string exceeds 4000 characters then an error is raised. Example: with data as ( -- Generates: -- - Numbers each 20 digits in length -- - Alph...
When working with APEX, handling JSON data structures is a common task, particularly when interacting with REST APIs. There may be instances where you need to merge or layer one JSON object onto another, such as when using default configurations in a...