@rgrzegorczyk

Using OPEN_QUERY_CONTEXT for Advanced Oracle APEX Analytics

2d ago · 4 min read · What if you want to calculate some data and display it in a separate region, while ensuring it respects all the filters selected in the other Interactive Report? Use OPEN_QUERY_CONTEXT in APEX. Exampl

RNRafal and 1 more commented

2

APEXLang, a Successor of Working Copies? How does it work with GIT Merge?

2d ago · 5 min read · In this article, I will test APEXLang compatibility with the Git merge command. What if two or more developers are working on the same APEX .apx file, each changing it in VS Code using their preferred

Set Active Tab in Oracle APEX

Feb 6 · 2 min read · Recently, I faced a business requirement. After redirecting to the page, set the specific tab to the active state. To make it more complex, the target page has many tabs and subtabs. Usually, Jon Dixon’s blog has everything I need, but this time his...

LOGGER - a quick start to debug, track errors or calculate code timings in PL/SQL

Jan 24 · 5 min read · What is LOGGER? It’s a PL/SQL logging and debugging framework. It’s super simple to install and use. Yes, you can also use it in PL/SQL within Oracle APEX or in any other application that uses Oracle Database. What are the benefits of using it for YO...

Smarter Popup LOV in Oracle APEX: Auto scroll to current month (or any other value)

Jan 15 · 2 min read · Challenge When you open a Popup LOV, it always starts at the top of the list. Imagine a list of 12 past and 12 future months (YYYY-MM) from 2025 to 2027 to choose from. The current month is 2026-01, but the first option we see when opening a Popup LO...