sql oracle procedure in function code example
Example 1: function in plsql
CREATE FUNCTION function_name … RETURN BOOLEAN IS
Definitions;
BEGIN
Statement;
RETURN "Hello World!";
END;
Example 2: procedure plsql
CREATE PROCEDURE nome_procedura [(parametri)] IS
Definizioni;
BEGIN
Corpo procedura;
END;