Edit D:\rfid\apache-tomcat-8.5.32\webapps\libsystem\WEB-INF\classes\db-update\F_UNIFIEDNO.SQL
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;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de