パッケージの作成

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  データベース構造の探索と変更 >

パッケージの作成

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

...


(C) 2019 Altova GmbH