Edit C:\Program Files\PLSQL Developer\Template\Program units\Package.tpl
create or replace package &Name is -- Author : $OSUSER -- Created : $DATE $TIME -- Purpose : &Purpose -- Public type declarations [#]type <TypeName> is <Datatype>; -- Public constant declarations <ConstantName> constant <Datatype> := <Value>; -- Public variable declarations <VariableName> <Datatype>; -- Public function and procedure declarations function <FunctionName>(<Parameter> <Datatype>) return <Datatype>; end &Name; / create or replace package body &Name is -- Private type declarations type <TypeName> is <Datatype>; -- Private constant declarations <ConstantName> constant <Datatype> := <Value>; -- Private variable declarations <VariableName> <Datatype>; -- Function and procedure implementations function <FunctionName>(<Parameter> <Datatype>) return <Datatype> is <LocalVariable> <Datatype>; begin <Statement>; return(<Result>); end; begin -- Initialization <Statement>; end &Name; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de