count characters in string oracle

CREATE OR REPLACE FUNCTION count_char ( p_data VARCHAR2 ,p_char VARCHAR2 DEFAULT ‘ ‘ ) RETURN VARCHAR2 IS v_loc NUMBER := 0; v_count NUMBER := 0; v_new_str VARCHAR2(32000); j binary_integer default 1; — BEGIN FOR i IN 1 .. LENGTH (p_data)