The PREPROCESSOR clause of the external table feature lets you do all sorts of amazing things. Here'...

Use compile time warnings to be warned if the compiler has identified an exception handler that does...

New to 12.2, you can now use the DEPRECATE pragma to document that a program unit (e.g., entire pack...

This example shows the deprecation of a PL/SQL package as a whole. Warnings will be issued for any r...

Use compile-time warnings to give you additional feedback on ways to improve your code. Set a partic...

With OUT and IN OUT parameters, you can benefit from adding the NOCOPY clause, which asks the compil...

This code accompanies a blog post by Bryn Llewellyn, PL/SQL Product Manager, with these three key ta...

This example shows the deprecation of a PL/SQL package. The compiler issues a custom warning message...

This example shows that if the argument for the pragma does not match the name in the declaration, t...

The DEPRECATE pragma must appear immediately after the declaration of the deprecated item. A warning...

This example shows that a reference to a deprecated entity x declared in unit type15_basetype type b...

Oh, so you think you know what's going on in your code base? You think all that code that you wrote ...

This examples shows that the DEPRECATE pragma may not be used to deprecate a nested procedure. The c...

The PL/SQL compile-time warning system can find many possible areas for improvement in your code. Fo...

This script turns on inlining (optimization level 3) and also compile-time warnings. The warning mes...

This is one of my favorite warnings: PLW-6017. Something bad is your way coming! This catch-all warn...

Use the PL/SQL compile time warnings system to detect when you are using names of pre-defined elemen...