CREATE OR REPLACE FUNCTION F_UNIFIEDNO(UNIFIEDNO IN VARCHAR) RETURN VARCHAR deterministic IS retval VARCHAR(200); BEGIN retval := LPAD(REGEXP_SUBSTR(UNIFIEDNO ,'[0-9]+', 1, 1),10,'*')||LPAD(REGEXP_SUBSTR(UNIFIEDNO ,'[0-9]+', 1, 2),10,'*'); RETURN retval; END;