Snippet Name: FUNCTIONS: Create function Description: Example of how to create a simple function. Also see:» Create a drop down menu from an array ... » FUNCTIONS: Deterministic » FUNCTIONS: Nested Functions » FUNCTIONS: IF statement » FUNCTIONS: date/time » FUNCTIONS: Sample functions » FUNCTIONS: drop » FUNCTIONS: Recompile » FUNCTIONS: DEBUG mode » FUNCTIONS: IN OUT parameter » FUNCTIONS: with output parameters » FUNCTIONS: with parameters » FUNCTIONS: without parameters » FUNCTIONS: Create function » FUNCTIONS: special restrictions » FUNCTIONS: System Privileges » TABLESPACE: Create temp tablespace » USERS: CREATE USER w/ authentication » Create Database Link » IN Function » Check Constraint: Create » Built-In Functions: CASE » Built-In Functions: DECODE » Create string by formatting an amount ... » SEQUENCE: Create sequence demo » SUBST and INSTR together » INSTR (InString) » SUBSTR (SubString) » Create Table INSERT (CTAS) » String Functions: REVERSE Comment: (none) Language: Highlight Mode: PLSQL Last Modified: March 13th, 2009
Description: Example of how to create a simple function.
Also see:» Create a drop down menu from an array ... » FUNCTIONS: Deterministic » FUNCTIONS: Nested Functions » FUNCTIONS: IF statement » FUNCTIONS: date/time » FUNCTIONS: Sample functions » FUNCTIONS: drop » FUNCTIONS: Recompile » FUNCTIONS: DEBUG mode » FUNCTIONS: IN OUT parameter » FUNCTIONS: with output parameters » FUNCTIONS: with parameters » FUNCTIONS: without parameters » FUNCTIONS: Create function » FUNCTIONS: special restrictions » FUNCTIONS: System Privileges » TABLESPACE: Create temp tablespace » USERS: CREATE USER w/ authentication » Create Database Link » IN Function » Check Constraint: Create » Built-In Functions: CASE » Built-In Functions: DECODE » Create string by formatting an amount ... » SEQUENCE: Create sequence demo » SUBST and INSTR together » INSTR (InString) » SUBSTR (SubString) » Create Table INSERT (CTAS) » String Functions: REVERSE
CREATE OR REPLACE FUNCTION fn_easy RETURN VARCHAR2 IS BEGIN RETURN 'This is a simple function'; END fn_easy; /
