@rgrzegorczyk

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...

Adding TOOLTIP to your SHUTTLE items list in Oracle APEX

Sep 24, 2025 · 3 min read · Some of you may like the Shuttle Item in APEX, some may not. But what if you really want to use it and additionally show a lot of data? Moreover, you want this data to be clearly visible on smaller screens. We need to add extra data as a tooltip, lik...

AI chatting with your Oracle Database - step by step for beginners [SQLcl MCP Server ]

Aug 8, 2025 · 3 min read · Heard of MCP? Test SQLcl MCP Server in just 5 minutes and see AI chatting with your database. Here's a quick intro. Warning Try the below steps only on your sandbox environments - free tiers, sample schemas, etc. Please don’t do it on real databases!...