UN World Innovation Day Hackaton – Projects and teams

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...
Indexing columns with non pure functions

Indexing columns with non pure functions

When you filter a column using a function, the optimizer does not use the indexes on that particular column because the function “transforms” the values and makes the index non useful to get the proper ROWIDs. To get around that hurdle, Oracle has...
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...
Get a daily backup report.

Get a daily backup report.

Let’s talk about physical backups and how to get a report based on your own “safety criteria” about the successfull backups needed to ensure a safe recovery scenario. In many places, they get reports when backups end successfully, or sometimes only...