Lets consider a hypothetical use case: – Limited Undo usage: either by disk space, or undo quota – Large table with many rows to remove/update. There are different ways to handle this situation and your particulars may vary. Considerations may include: Creating a new table with just the rows desired, using parallel DML, etc. Ask Tom […]
Several times during my career, I have encountered the need or the question of how to run operating systems commands from the Oracle Database. Doing research on the topic – there are two main ways to accomplish this task. Java or DBMS_SCHEDULER Java Once Oracle included JAVA in the database (v8 + review the version […]
I run a lot of VM instances of Oracle. Some are to test different installations and versions of Oracle, APEX, APEX Listener, ORDS, etc. It is very frustrating to fire one up and then get faced with the dreaded 400 error from the Oracle connection. Then I have to remember which standard (of several) I […]
I had a requirement today to use the Saved Reports feature of APEX to create a list of reports for users to pick from. The issue was with the default report name. We wanted the name to reflect what the report was designed for. Showing a label of “All Data” was mare appropriate for the […]
Disclaimer: These notes were written in November 2015. The services described here may change rapidly based on Amazon offerings. Please verify with Amazon as some of this information may have changed. Recently I have had the opportunity to test and learn a little about the Amazon web services (AWS) Relational Database Service (RDS) offering. RDS […]
In my recent travels, I have encountered some individuals who ask what I do. I have been working on my elevator pitch, and it is harder than I imagined. When I mention that I have a long history with Oracle APEX, I am often greeted with the question…. Q: What is Oracle Application Express (APEX)? Short […]
Example Application and Presentation from KSCOPE 14 about APEX cookies and automatic authentication.