updateHR_USER_ZSJ_推广_oksetlogin_name=fn_getpy_1(名称)||'@'|| (casewhen newoulike'%潮州供电局%'then'cz.gd.csg.cn'when newoulike'%东莞供电局%'then'dg.gd.csg.cn'whennewoulike'%佛山供电局%'then'fs.gd.csg.cn'when newoulike'%河源供电局%'then'hy.gd.csg.cn'whennewoulike'%惠州供电局%'then'hz.gd.csg.cn'when newoulike'%江门供电局%'th

instr(login_name,'@')-1--在@之前字符串长度 regexp_substr(login_name,'[A-Z|a-z]+',1)--获取@之前非数字的字符串 substr(login_name,1,instr(login_name,'@')-1)--获取@之前的字符串 substr(login_name,instr(login_name,'@'))--获取@之后的字符串

selectname,login_name,fn_getpy_1(name),fn_getpy_1(case wheninstr(name,'曾')>0thenREPLACE(name,'曾','zeng') wheninstr(name,'兴')>0thenREPLACE(name,'兴','xing') wheninstr(name,'毛')>0thenREPLACE(name,'毛','mao') wheninstr(name,'仇')>0thenREPLACE(name,'仇','mao') elsenameend)||substr(login_

selectu1.name,u1.login_name,regexp_substr(login_name,'[0-9]+') fromisc_useru1