Blog
The Café Database Blog
How to build a chain of jobs with DBMS_SCHEDULER
A few days ago, in the Café Database Discord Server Administration channel, someone asked how a chain of job executions could be implemented with DBMS_SCHEDULER. The idea is that when a task finishes, it waits two minutes and runs again. The problem is that the...
SPOUG2024 chronicle
I’m writing these lines on my way back to Valencia after attending the annual SPOUG event in Madrid. The Oracle Users Group of Spain has grown strong, and the event was centered around six conference rooms where, simultaneously, a series of talks and presentations on...
Upgrade your database DST… or not?
In 2019 they decided in Chile that the winter time adjustment would be 5 months, instead of the usual 3 months. Morocco also decided to move its time with respect to GMT from +00 to +01. These changes that you may think do not affect you in the least, unless you live...
Leap years in the Oracle database
Leap years have been a headache throughout history. Also for computer systems and databases.
Discover the origin of these problems and let’s take a look at date bugs that are still present in Oracle23c
A chain of synonyms #JoelKallmanDay
This one is about bad practices. The use of synonyms. If you have felt a cold sweat, you probably experienced something similar. Many users want to access application tables "transparently." Note that I put it in quotes because calling "transparent" "without prefixing...
UN World Innovation Day Hackaton – Projects and teams
On May 12, a five-day Hackathon was held on the occasion of the World Innovation day of the United Nations. I had the honor of mentoring the participating teams. During this time they had to come up with an app that would provide an improvement for the world. Various...