My Biggest Takeaways from the APEX World Keynote About Oracle APEX 26.1 I watched the keynote at APEX World with huge excitement and it has been a long time since a new Oracle APEX feature got me this

Using oracledb.ConnectionPool is straightforward: first, you create the pool, and then you use the pool and connection object as a context manager. Like this: pool = oracledb.ConnectionPool(**param…

A smarter ERP starts with a clearer system landscape. You can’t modernize what you don’t understand.

It's that time of the year. It's time to say goodbye to summer. It's time to set the clock and get back to normal time. ... It's also time f...

Using a REST Media Resource as an image source

UUIDs are useful, especially when you expose data in REST APIs, but there are cases where you may want to stick to the good old sequence-based primary key. UUIDs in Oracle Database #JoelKallmanDay UUI...

Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.

Triggered by traumatic DML errors ? Well, here's one flashback you won't mind having...

Dynamically generate a Google XML Sitemap from an Oracle APEX application using PL/SQL and SQL/XML, ensuring your site is fully indexed by Google.

TL;DR: You don't have to be a genius to solve problems. And there is no shame in not-knowing or not understanding all the geeky details. Ma...

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 and times as distinct rows. In some reports though, it is more useful to show a rolling window of time.

TL;DR No, SYSDATE is not deterministic. However, it behaves very similarly to a deterministic function within an Oracle Database SQL statement. Background On a customer site, we used faketime on the O...

Learn how implicit RAW-to-VARCHAR2 conversions in Oracle break histograms, hurt optimizer estimates, and how to fix them safely.

Login to LinkedIn to keep in touch with people you know, share ideas, and build your career.

Dashboard, Test Suite rework