call function plsql example

Example 1: function in plsql

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

Example 2: create a plsql function and call

CREATE OR REPLACE FUNCTION welcome_msgJune ( p_name IN VARCHAR2) RETURN VAR.CHAR2
IS
BEGIN
RETURN (‘Welcome ‘|| p_name);
END;
/
DECLARE
lv_msg VARCHAR2(250);
BEGIN
lv_msg := welcome_msg_func (‘Guru99’);
dbms_output.put_line(lv_msg);
END;
SELECT welcome_msg_func(‘Guru99:) FROM DUAL;