CODE EXAMPLE FOR SQL

pl sql create function

CREATE OR REPLACE FUNCTION function_name
([parameter(s)])
RETURN return_datatype
AS
[declaration]
BEGIN
[EXCEPTION]
END [function_name];