How to use Tabs Container in DA e.g. to show/hide region - Dominik's Tips and Tricks in APEX#4 (in short DTaTiA#4 🤷♂️)
Mar 1 · 3 min read · Have you ever wanted to trigger an action further down the page with a dynamic action when you click a Tab in the Tabs Container? If so, stay a while and listen ;) What was the business case for this
Join discussion
Oracle AI Vector Search: DML and DDL Operations on Vector Columns
Feb 26 · 10 min read · Oracle Database 23ai introduces the VECTOR data type, enabling you to store AI embeddings alongside traditional business data. Understanding how to perform Data Manipulation Language (DML) and Data De
Join discussion
The Likely Obvious Oracle Tip #8
Feb 19 · 2 min read · One of the new features offered by Oracle Database 26ai is the enhancement of the DEFAULT ON NULL clause for columns during UPDATE. In this article, I will present the key concepts and my personal opinion on this improvement and the concept itself. I...
Join discussion
The Likely Obvious Oracle Tip #10
Feb 18 · 5 min read · Intro Visual Studio Code is a tool I use every day. As an APEX Developer, I probably use only some of its features, but it's clear that this tool has made my daily work much easier. In this article, I'll focus on selected features, so if you're inter...
Join discussion
The Hidden Cost of Login (Redo)
Feb 17 · 5 min read · I was investigating an issue where there were a lot of user logins to Oracle database via listener due to misconfigured connection pool. This post explains why many logins could be a problem. Most would first think of the cost of process creation, me...
Join discussionfrm2xml Troubleshooting
Feb 16 · 3 min read · Why are you converting Oracle Forms to APEX? Did you know Pretius has specialized AI tooling for Oracle Forms to APEX projects. If you are running into issues, perhaps this troubleshooting guide can help you. Basics Before reading anything; your firs...
Join discussion
The Likely Obvious Oracle Tip #7
Feb 11 · 6 min read · Introduction From time to time, I log into the INTERNAL workspace to set up a new APEX workspace. In most cases, it is based on an existing database schema. In some situations, I need to create a new schema. Here, APEX offers us two options: creating...
Join discussion
Oracle APEX Banner to Instantly Avoid Dev vs Prod Mistakes
Feb 9 · 4 min read · Working in Oracle APEX across multiple environments DEV, TEST, and PROD is risky business if you don’t have clear visual indicators. All it takes is one slip-up to run tests in production or drop data where you shouldn’t. In this guide, I’ll walk you...
Join discussion