Skip to content

Instantly share code, notes, and snippets.

@AndrewRussellHayes

AndrewRussellHayes/procedure.sql

Created July 9, 2014 12:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save AndrewRussellHayes/f664954d265324773200 to your computer and use it in GitHub Desktop.
Save AndrewRussellHayes/f664954d265324773200 to your computer and use it in GitHub Desktop.
Download ZIP
pl/sql procedure template
Raw
procedure.sql
/*
AUTHOR:Joe Developer
ACCEPTS:These Args
DOES:Performs Function
RETURNS:Return Value
DEPENDENCIES:Uses/Needs
NOTES: Special Considerations
*/
CREATE [OR REPLACE] PROCEDURE procedure_name
[ (parameter [,parameter]) ]
IS
[declaration_section]
BEGIN
executable_section
[EXCEPTION
exception_section]
END [procedure_name];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment