Creating Packages

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Exploring and Changing the Database Structure >

Creating Packages

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