From an operational perspective, I argue that the use of ANSI syntax for JOINs is superior to that of Oracle’s native syntax.
Now that Flashback Data Archive is now included in the base 184.108.40.206 license, I had the crazy idea to mix it with Database Editioning.
I have recently used SQLTXPLAIN to solve a production performance issue. This post is about my experiences with this tool.
Today, I had a question about how to exchange the names of two (2) columns in a table. Apparently, there was a transposition error in the data loading program.