Rafal Grzegorczyk

@rgrzegorczyk

Oracle APEX & PL/SQL Developer at Pretius Low-Code

Kielce, POLANDJoined November 2022

About

Oracle APEX & PL/SQL Developer with 10 years of experience in IT, including financial systems for government administration, energy, banking and logistics industry. Enthusiast of database automation. Oracle ACE Associate. Certified Liquibase database versioning tool fan. Speaker at Kscope, APEX World, SOUG, HrOUG, POUG and DOAG. Likes swimming in icy cold lakes in winter and playing basketball.

Available for

Nothing here yet.

Rafal Grzegorczyk's blogs

Keep It Simple. Developer's tips.rafal.hashnode.dev49 posts

Articles Threads Comments2

Recently published

rafal.hashnode.dev

Set Active Tab in Oracle APEX

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

Feb 62 min read

rafal.hashnode.dev

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

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

Jan 245 min read

rafal.hashnode.dev

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

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

Jan 152 min read

rafal.hashnode.dev

Adding TOOLTIP to your SHUTTLE items list in Oracle APEX

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

Sep 24, 20253 min read

rafal.hashnode.dev

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

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

Aug 8, 20253 min read

Rafal Grzegorczyk

About

Available for

Rafal Grzegorczyk's blogs

Recently published

Set Active Tab in Oracle APEX

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

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

Adding TOOLTIP to your SHUTTLE items list in Oracle APEX

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

Search Hashnode

Rafal Grzegorczyk

About

Available for

Rafal Grzegorczyk's blogs

Recently published

Set Active Tab in Oracle APEX

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

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

Adding TOOLTIP to your SHUTTLE items list in Oracle APEX

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