The interactive grid has a feature that collapse and expands the control break. This feature is missing from interactive reports, but it's relatively easy to add the same feature with dynamic action and JavaScript.

Continue Reading

Here is how you can add tooltip to Interactive Grid column headers. For this I have placed tooltip text to IG column help and add title attribute column headers using small JavaScript code.

Continue Reading

Oracle REST Data Service (ORDS) has feature to scan uploaded files for viruses. You can install e.g. C-ICAP and ClamAV for that purpose. Here are steps how to do that on Ubuntu 18.04 server assuming you have already working ORDS installation on same or different server.

Continue Reading

Previously I did write post about APEX and shuttle filter. I received comments that filtering does not work when shuttle have parent cascading item. Issue was that JavaScript code stores shuttle values to variable for filtering only on page load.

Continue Reading

You can configure automatically start and stop Oracle XE 18c database on operating system startup and shutdown. See details from installation guide. I did install XE 18c on CentOs 7 and executed steps mentioned in installation guide. When viewing database alert.log after system reboot, noticed that database wasn't actually stopped properly. Processes were just killed. I didn't investigate more why that happens on my system. For workaround I did revert steps mentioned in installation guide and created service file for systemd.

Continue Reading