ORACLE PLSQL - FUNCTION

1. CREATE INDEX
2. DECODE
3. TO_CHAR
4. TO_DATE
5. SELECT
6. GRANT
7. INSERT
8. TUNNING
9. UPDATE
10. CREATE USER

FUNCTION

	CREATE OR REPLACE FUNCTION f_name (params) RETURN returntype
	IS
	  res returntype;
	BEGIN
	   code...
	   
	   RETURN res;
	END;

	CREATE OR REPLACE FUNCTION f_desc(p_code in number)
	  RETURN char IS
	v_res varchar2(100):='';
	
	BEGIN
	
	SELECT desc INTO v_des
	FROM t_datos
	WHERE code=:p_code;
	
	return v_res;
	
	EXCEPTION
	WHEN NO_DATA_FOUND THEN
	    return 'error';
	WHEN OTHERS THEN
	  RAISE_APPLICATION_ERROR(-20665,'sqlerrm);
	END;