April 2020

I woke up last night with a brilliant solution to a problem that’s been bugging me for more than a year. How does a call to report_sql_monitor() manage to produce output like this:

Compilers and Interpreters Compatible with PL/SQL The PL/SQL programming language, created by Oracle, is the most well-known database-oriented procedural language in existence. While everyone who knows about PL/SQL knows it’s available in the Oracle Database, what most people don’t know is that a number of companies and individuals have implemented their own compilers and interpreters […]

The post Imitation is the Sincerest Form of Flattery appeared first on Oracle Internals.

With a solid history of use, Oracle’s PL/SQL is one of the top twenty programming languages in the world. OverviewWhile many people tend to think of it strictly as a database procedural language, PL/SQL is far more powerful than most give it credit for. PL/SQL is so popular, in fact, that at least fifteen independent […]

The post Demystifying PL/SQL: The Life of a Compilation Unit appeared first on Oracle Internals.

In previous articles, I discussed how Automatic Indexing has the capability to add columns or reorder the column list of previously created Automatic Indexes. However, how does Automatic Indexing handle these types of scenarios with regard to existing manually created indexes? To investigate, let’s create a table identical to the table I created in my […]