function in plsql

Solutions on MaxInterview for function in plsql by the best coders in the world

showing results for - "function in plsql"
Lisa
14 Mar 2017
1CREATE FUNCTION function_name … RETURN BOOLEAN IS
2	Definitions;
3BEGIN
4	Statement;
5	RETURN "Hello World!";
6END;
Élise
06 Feb 2018
1CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
2    cnumber NUMBER;
3BEGIN
4    cnumber := 2;
5    RETURN (cnumber * param1);
6EXCEPTION
7    WHEN OTHERS THEN
8        raise_application_error(-20001, 'An error was encountered - '
9            || sqlcode || ' -ERROR- ' || sqlerrm);
10END;