Top 5: blog posts of August 2025

September 1, 2025 No Comments

August is over, and dozens of excellent articles were published, but to save you from having to spend hours separating the wheat from the chaff, here is my monthly list of what I consider to be essential reading, focused on those that offer fresh insights or deal with common issues in an easy-to-understand and entertaining way.

I hope you enjoy reading it as much as I do, so here it is, without further delay!

Warning: this content may cause tachycardia in DBAs who believe that DB Link passwords are always protected

Roberto shows us how to obtain the password used in a dblink, and in less than 3 seconds! (I had to try it to believe it).

I want to read it!

Non-Positional INSERT statement – the insider story

Who hasn't had trouble trying to understand an INSERT that is giving us problems? Gerald teaches us all about how this is no longer an issue since Oracle 23.9.

I want to read it!

Online COMPATIBLE raise starting with 23.9

Modifying the COMPATIBLE parameter was always a headache, but Rodrigo shows us how simple it is now from Oracle 23.9 onwards.

I want to read it!

Oracle External Tables and really really long lines

Do you have an external table with huge LOBs? Let Mike show you how to define it correctly and avoid common mistakes.