Looking for plsql Keywords? Try Ask4Keywords

plsqlPakete


Syntax

  • CREATE [ODER REPLACE] PACKAGE Paketname

    [AUTHID {CURRENT_USER | DEFINER}]

    {IS | WIE}

    [PRAGMA SERIALLY_REUSABLE;]

    [collection_type_definition ...]

    [record_type_definition ...]

    [Untertypdefinition ...]

    [collection_declaration ...]

    [Konstantenerklärung]

    [exception_declaration ...]

    [object_declaration ...]

    [record_declaration ...]

    [variable Aussage ...]

    [cursor_spec ...]

    [function_spec ...]

    [procedure_spec ...]

    [call_spec ...]

    [PRAGMA RESTRICT_REFERENCES (Zusicherungen) ...]

    END [Paketname];

  • PAKET ERSTELLEN ODER ERSETZEN PackageName IS

    FUNKTION Funktionsname (Parameter1 IN VARCHAR2, Parameter2 IN NUMMER) RETURN VARCHAR2;

    END PackageName;

  • ERSTELLEN SIE [ODER ERSETZEN] PACKAGE BODY Paketname

    {IS | WIE}

    [PRAGMA SERIALLY_REUSABLE;]

    [collection_type_definition ...]

    [record_type_definition ...]

    [Untertypdefinition ...]

    [collection_declaration ...]

    [Konstantenerklärung]

    [exception_declaration ...]

    [object_declaration ...]

    [record_declaration ...]

    [variable Aussage ...]

    [Cursor_Body ...]

    [function_spec ...]

    [procedure_spec ...]

    [call_spec ...]

    END [Paketname];

  • ERSTELLEN ODER ERSETZEN DES PAKETKÖRPERS PackageName IS

    FUNCTION FunctionName (Parameter1 IN VARCHAR2, Parameter2 IN NUMMER) RETURN VARCHAR2 IS

    Erklärungen

    START

    auszuführende Anweisungen

    RETURN Variable Varchar2

    END Funktionsname;

    END PackageName;

Pakete Verwandte Beispiele