DatabaseSpy supports the definition of PL/SQL packages for Oracle databases. Packages are objects that group related PL/SQL types, items, and subtrees into modules and thus allow you to re-use code.
Packages consist of a package specification and an optional package body. The specification is the interface and the body defines cursors and subprograms.
Packages are defined with the commands:
CREATE [OR REPLACE] PACKAGE package_name
[CREATE [OR REPLACE] PACKAGE BODY package_name
© 2019 Altova GmbH