Discontinuation Notice
@PhilippSalvisberg no longer work for Trivadis - Part of Accenture and no one at Trivadis/Accenture will continue this project. Therefore, this GitHub repository was archived on 30 August 2024.
PL/SQL Unwrapper for SQL Developer
Introduction
PL/SQL Unwrapper for SQL Developer is a free extension to unwrap PL/SQL code wrapped with the wrap utility of the Oracle Database Server version 10g, 11g, 12c, 18c or 19c.
Example
Open a wrapped PL/SQL unit (procedure, function, package specification, package body, type specification or type body) in a SQL Developer editor
Right-click within editor to show the pop-up-menu. Select Unwrap
or simply press Ctrl-Shift-U
to unwrap the code.
The editor content is replaced by the unwrapped code.
By default the unwrapped code does not contain a valid DDL statement. In this case the CREATE
is missing. You may change this behaviour in in the preferences.
Check the Add ‘CREATE OR REPLACE'
option…