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

Unordered sorts

For the result of an SQL query to be ordered, the only valid clause is ORDER BY. Oracle only guarantees the ordered return of rows when ORDER BY is set as the sort criteria. I have repeated these two phrases like a mantra thousands of times. Any other way to get the...