Code Library - Oracle Live SQL

Skip to Main Content

Script
EXPLAIN PLAN

Use the EXPLAIN PLAN statement to determine the execution plan Oracle Database follows to execute a ...

EXPLAIN PLAN, performance, access path

21 245

7.7 years ago Mike Hichwa (Oracle)
Script
12.2: Use DEPRECATE Pragma to Document Deprecated Units

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

deprecate,plw

1 17

6.4 years ago Steven Feuerstein
Script
Deprecation of a PL/SQL Package with a Custom Warning

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

LNPLS 12.2.0.1 DEPRECATE PRAGMA

0 10

6.4 years ago Sarah Hirschfeld (Oracle)
Script
Misplaced DEPRECATE Pragma

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

LNPLS 12.2.0.1 DEPRECATE PRAGMA PLW-06021

0 8

6.4 years ago Sarah Hirschfeld (Oracle)
Script
Deprecation of Inherited Object Types

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

LNPLS 12.2.0.1 DEPRECATE PRAGMA

0 8

6.4 years ago Sarah Hirschfeld (Oracle)
Script
Deprecation of an Overloaded Procedure

This example shows the DEPRECATE pragma applies only to a specific overload of a procedure name. Onl...

LNPLS 12.2.0.1 DEPRECATE PRAGMA

0 5

6.4 years ago Sarah Hirschfeld (Oracle)

row(s) 1 - 6 of 6