Handy Regexp trick for Listaggs
I use the listagg function to generate a comma separated list of employees who work in department 10 from the EMP
Read MoreA Backup for My Brain!
I use the listagg function to generate a comma separated list of employees who work in department 10 from the EMP
Read MoreI’ve recently come across the issue of static images not working and my custom theme roller theme not being applied
Read MoreI have a table with an “active” flag column that stores either Y or N. In an APEX report, rather
Read MoreIf you’re working on a Mac, you may have encountered the problem of trying to use ssh with a .ppk
Read MoreIn a previous post I explained how to set up a SQL Developer connection with SSH using a .pem key
Read MoreInteractive reports can be enabled to be accessed through REST. Doing so is pretty easy if you know where to
Read MoreThis is just a quick & dirty re-blog of a handy article I found. http://weblogs.asp.net/bleroy/getting-your-raspberry-pi-to-output-the-right-resolution
Read MoreHere is a great post by Dimitri regarding HTTPS: Dimitri Gielis Blog (Oracle Application Express – APEX): Please, use HTTPS
Read MoreI recently had the need to display a color spectrum, depending on a column value, in a report. The colors
Read MoreIf you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)
Read More