pl sql functions and procedures 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;