Fear No SQL
The last several years I’ve participated in the Joel Kallman Day tributes with articles about SQL and PL/SQL. While there are no requirements for article topics, this year I wanted to contribute something within the framework Joel was best known for… APEX. Many reports aggregate data over time periods and will usually return different dates…
When you duplicate an Interactive Grid in APEX, if that region has a process to perform Automatic Row Processing DML; the new, duplicated region, will not have a DML process created for it. You can create a DML process for the new region from scratch or duplicate that of the original Interactive Grid and then…
I’ve had multiple conversations over the past few years that were variations on a theme. They generally go something along the lines of these… “We’re starting a new project and we plan to use APEX. How are we going to keep users from getting into the database and mucking with stuff?” “We’re starting a new…
What is ASH? AWR and Activity Types Average Active Sessions Graphical Visualizations (this page) Up to this point in my ASH series all of the output was simply rows and columns of data, sometimes augmented with an ascii, text based chart. This time I’ll explore a few different tools to construct better visualizations. One of…