oracle防泄密对姓名和身份证处理语句

select substr(NAME,1,1) || '*' || substr(NAME,length(NAME),length(NAME)) NAME from TY_EMBASIC;

UPDATE TY_EMBASIC SET NAME = substr(NAME,1,1) || '*' || substr(NAME,length(NAME),length(NAME));

select substr(CARD_ID,1,6) || '*' || substr(CARD_ID,length(CARD_ID) - 3,length(CARD_ID)) CARD_ID from TY_EMBASIC;

UPDATE TY_EMBASIC SET CARD_ID = substr(CARD_ID,1,6) || '*' || substr(CARD_ID,length(CARD_ID) - 3,length(CARD_ID));