Skip to Main Content
Oracle
Live SQL
Help
Sign In
Home
SQL Worksheet
My Session
Previous Sessions
Utilization
NLS
Schema
Quick SQL
My Models
My Scripts
My Tutorials
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
Results Per Page
60
120
180
240
300
360
420
480
540
600
Reset Search
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'...
Script
external table
1
35
4.8 years ago
Steven Feuerstein (Oracle)
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...
Script
raise,warning,plw
1
26
5.1 years ago
Steven Feuerstein (Oracle)
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...
Script
deprecate,plw
1
17
4.3 years ago
Steven Feuerstein (Oracle)
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...
Script
12.2.0.1 DEPRECATE PRAGMA
0
14
4.3 years ago
Oracle
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...
Script
WARNING,ERROR,plw
0
9
5.5 years ago
Steven Feuerstein (Oracle)
Use Warnings to Identify NOCOPY Opportunities
With OUT and IN OUT parameters, you can benefit from adding the NOCOPY clause, which asks the compil...
Script
WARNING,ERROR,plw,nocopy
1
9
3.2 years ago
Steven Feuerstein (Oracle)
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...
Script
LNPLS 12.2.0.1 DEPRECATE PRAGMA
0
8
4.3 years ago
Oracle
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...
Script
LNPLS 12.2.0.1 DEPRECATE PRAGMA
0
7
4.3 years ago
Oracle
Misplaced DEPRECATE Pragma
The DEPRECATE pragma must appear immediately after the declaration of the deprecated item. A warning...
Script
LNPLS 12.2.0.1 DEPRECATE PRAGMA PLW-06021
0
7
4.3 years ago
Oracle
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...
Script
warning,reserved word,keyword
0
7
3.1 years ago
Oracle
Deprecation of Inherited Object Types
This example shows that a reference to a deprecated entity x declared in unit type15_basetype type b...
Script
LNPLS 12.2.0.1 DEPRECATE PRAGMA
0
6
4.3 years ago
Oracle
Find Unused Code In Programs
The PL/SQL compile-time warning system can find many possible areas for improvement in your code. Fo...
Script
WARNING,ERROR,plw,unused
0
5
3.2 years ago
Steven Feuerstein (Oracle)
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 ...
Script
WARNING,ERROR,plw,unreachable
0
4
3.2 years ago
Steven Feuerstein (Oracle)
Inlining Optimization and PL/SQL Warnings
This script turns on inlining (optimization level 3) and also compile-time warnings. The warning mes...
Script
inlining,warnings,subprograms
0
4
2 years ago
Steven Feuerstein (Oracle)
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...
Script
LNPLS 12.2.0.1 DEPRECATE PRAGMA PLW-06022
0
3
4.3 years ago
Oracle
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...
Script
error,warning,plw,runtime
0
2
3.2 years ago
Steven Feuerstein (Oracle)
Avoid Using Pre-Defined Names
Use the PL/SQL compile time warnings system to detect when you are using names of pre-defined elemen...
Script
error,warning,plw
0
0
3.2 years ago
Steven Feuerstein (Oracle)
row(s) 1 - 17 of 17