Oracle下解决手机号中间4位, 手机号星号显示

Oracle下解决手机号中间4位, 手机号星号显示

--Oracle下解决手机号中间4位隐藏方案
CREATE TABLE TEST_USER(
    ID NUMBER(10) NOT NULL,
    NAME VARCHAR2(50),
    MOBILE VARCHAR2(50),
    PRIMARY KEY(ID)
);

INSERT INTO TEST_USER VALUES(1,'张三','13312341234');
INSERT INTO TEST_USER VALUES(2,'李四','');
INSERT INTO TEST_USER VALUES(3,'小明',NULL);

SELECT
	ID,
	NAME,
	(CASE WHEN MOBILE IS NULL THEN '' WHEN LENGTH(MOBILE)<1 THEN '' ELSE (SUBSTR(MOBILE,0,3)||'****'||SUBSTR(MOBILE,7,4)) END) AS MOBILE
FROM TEST_USER