#oracle
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...
Update: thanks to Connor McDonald for pointing out how to fix this issue (see "The Solution" and subsequent explanation below). Connor wrote a...
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...
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...
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...
Note: the comparisons in this article also applies to [[:lower:]] vs [a-z] regexp patterns. Oracle regular expressions (regexp) support both...