FLIGHTS open dataset.

FLIGHTS open dataset.

In 2013, I published the book SQL Optimization in Oracle. Until then, when I taught SQL or PL/SQL training, the “universal” tables EMP and DEPT were enough for me to demonstrate practically everything. The problem came when I started needing examples with a bit more...
OWNER vs JOB_CREATOR in DBMS_SCHEDULER

OWNER vs JOB_CREATOR in DBMS_SCHEDULER

A few days ago I received an email from a subscriber. The question looked simple… but it came with a twist: Good morning Javier, I have two database users: 1. OWNER 2. DBA DBA creates a job where the owner is user OWNER. The job runs without issues. The user DBA is...
Insufficient privileges and PL/SQL

Insufficient privileges and PL/SQL

If you have been working with Oracle for some time, you have most likely seen this scenario: From SQL, an operation works. From an anonymous PL/SQL block, it also works. From a stored procedure… ORA-01031: insufficient privileges. The usual way to try to fix it...
Upgrade your database DST… or not?

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