#sql
Read more stories on Hashnode
Articles with this tag
I recently had to generate a sitemap.xml for an public facing APEX application. The official sitemap protocol has the following example: <?xml...
The KEEP clause in Oracle ยท Suppose you want to find the maximum salary for each job in the emp table. This is very easy using using the max...
Note: the comparisons in this article also applies to [[:lower:]] vs [a-z] regexp patterns. Oracle regular expressions (regexp) support both...
In Oracle the listagg function is limited to 4000 characters. If the resulting string exceeds 4000 characters then an error is raised. Example: with ...
When working with APEX, handling JSON data structures is a common task, particularly when interacting with REST APIs. There may be instances where you...
Let's start with a little quiz. Without checking, what do you think happens/returns running the following query: -- Note the two digit year select...
