How to use Text Messages for Constants ยท It's very common for APEX application to have application level items (usually these are named APP_... or G_......
Last week SQL Developer for VS Code was released (direct link to VS Code extension here). If you're not using VS Code (VSC) I highly suggest you...
I recently had to generate a sitemap.xml for an public facing APEX application. The official sitemap protocol has the following example: <?xml...
Every APEX page item has a Server Side condition which controls whether the item is rendered on the page. They're various server side condition...
By default Oracle (and inherently APEX) is case sensitive, i.e. MARTIN is not the same string as martin. This is apparent in both sorting (order by)...
Update: thanks to Connor McDonald for pointing out how to fix this issue (see "The Solution" and subsequent explanation below). Connor wrote a...