Business intelligence and data warehousing tips and trends for database administrators
To improve the performance of your code that uses numerous table variables, consider adding the optimizer hint RECOMPILE.
Oracle 21c now offers the possibility of using some PL/SQL data types in SQL*PLus, with some restrictions. Read on to see what types are available and how to use them.
SQL etc Archives