Skip to Main Content
Oracle
Live SQL
Help
Sign In
Dark Mode
Home
Home
SQL Worksheet
SQL Worksheet
My Session
My Session
Previous Sessions
Previously Viewed
Utilization
NLS
Schema
Schema
Quick SQL
Quick SQL
My Models
My Scripts
My Scripts
My Tutorials
My Tutorials
Code Library
Code Library
Code Library
Breadcrumb
Search
Area
All
SQL General - 1
PL/SQL General - 16
Category
All
Types
All
Tutorials
Scripts
Sort By
Date Added
Executions
Name
Likes
Sort Order
Ascending
Descending
Results Per Page
60
120
180
240
300
360
420
480
540
600
Reset Search
Script
Use External Table Feature to List Files in Directory
The PREPROCESSOR clause of the external table feature lets you do all sorts of amazing things. Here'...
external table
1
58
8.6 years ago
Steven Feuerstein
Script
Automatically Detect Exception Handlers That ''Swallow Up'' Errors
Use compile time warnings to be warned if the compiler has identified an exception handler that does...
raise,warning,plw
1
40
8.9 years ago
Steven Feuerstein
Script
Deprecation of a PL/SQL Package
This example shows the deprecation of a PL/SQL package as a whole. Warnings will be issued for any r...
12.2.0.1 DEPRECATE PRAGMA
0
21
8.1 years ago
Sarah Hirschfeld (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
8.2 years ago
Steven Feuerstein
Script
Use Warnings to Identify NOCOPY Opportunities
With OUT and IN OUT parameters, you can benefit from adding the NOCOPY clause, which asks the compil...
WARNING,ERROR,plw,nocopy
1
14
7 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
13
8.1 years ago
Sarah Hirschfeld (Oracle)
Script
Mismatch of the Element Name and the DEPRECATE Pragma Argument
This example shows that if the argument for the pragma does not match the name in the declaration, t...
LNPLS 12.2.0.1 DEPRECATE PRAGMA
0
11
8.1 years ago
Sarah Hirschfeld (Oracle)
Script
Reserved words, keywords, and the ends of labeled blocks
This code accompanies a blog post by Bryn Llewellyn, PL/SQL Product Manager, with these three key ta...
warning,reserved word,keyword
0
10
6.9 years ago
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
10
8.1 years ago
Sarah Hirschfeld (Oracle)
Script
Improve Code QA by Treating Warning as Error
Use compile-time warnings to give you additional feedback on ways to improve your code. Set a partic...
WARNING,ERROR,plw
1
10
9.3 years ago
Steven Feuerstein
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
9
8.1 years ago
Sarah Hirschfeld (Oracle)
Script
Deprecation Only Applies to Top Level Subprogram
This examples shows that the DEPRECATE pragma may not be used to deprecate a nested procedure. The c...
LNPLS 12.2.0.1 DEPRECATE PRAGMA PLW-06022
1
8
8.1 years ago
Sarah Hirschfeld (Oracle)
Script
Find Unused Code In Programs
The PL/SQL compile-time warning system can find many possible areas for improvement in your code. Fo...
WARNING,ERROR,plw,unused
0
7
7 years ago
Steven Feuerstein
Script
Find Unreachable Code with PL/SQL Warnings
Oh, so you think you know what's going on in your code base? You think all that code that you wrote ...
WARNING,ERROR,plw,unreachable
0
6
7 years ago
Steven Feuerstein
Script
Inlining Optimization and PL/SQL Warnings
This script turns on inlining (optimization level 3) and also compile-time warnings. The warning mes...
inlining,warnings,subprograms
0
4
5.8 years ago
Steven Feuerstein
Script
Use Compile-Time Warnings to Detect Runtime Errors
This is one of my favorite warnings: PLW-6017. Something bad is your way coming! This catch-all warn...
error,warning,plw,runtime
0
2
7 years ago
Steven Feuerstein
Script
Avoid Using Pre-Defined Names
Use the PL/SQL compile time warnings system to detect when you are using names of pre-defined elemen...
error,warning,plw
0
1
7 years ago
Steven Feuerstein
row(s) 1 - 17 of 17