CREATE FUNCTION function_name … RETURN BOOLEAN IS	Definitions;
BEGIN	Statement;	RETURN "Hello World!";
END;

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS cnumber NUMBER;
BEGIN cnumber := 2; RETURN (cnumber * param1);
EXCEPTION WHEN OTHERS THEN raise_application_error(-20001, 'An error was encountered - ' || sqlcode || ' -ERROR- ' || sqlerrm);
END;

DECLARE -- Declare variables v_number1 NUMBER := 10; v_number2 NUMBER := 5; v_result NUMBER;
BEGIN -- Perform calculations v_result := v_number1 + v_number2; -- Print the result DBMS_OUTPUT.PUT_LINE('The result of ' || v_number1 || ' + ' || v_number2 || ' is: ' || v_result); -- Perform another calculation v_result := v_number1 * v_number2; -- Print the second result DBMS_OUTPUT.PUT_LINE('The result of ' || v_number1 || ' * ' || v_number2 || ' is: ' || v_result);
END;
/