Posted on Wednesday, April 6, 2022 Collapse Interactive Report Control Break Category APEX Tips and Tricks 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
Posted on Saturday, March 26, 2022 Add tooltip to Interactive Grid column headers Category APEX Tips and Tricks 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
Posted on Thursday, April 8, 2021 C-ICAP and ClamAV for ORDS Category Oracle Database 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
Posted on Friday, February 21, 2020 APEX and shuttle filter - Revisited Category APEX and jQuery 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
Posted on Sunday, February 17, 2019 Stopping XE 18c properly when shutting down CentOs 7 Category Oracle Database 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