select substr('sdfsdf@sina.com', instr('sdfsdf@sina.com', '@')) from dual; SUBSTR('SDFSDF@SINA.COM',INSTR ------------------------------ @sina.com select substr('sdfsdf@sina.com', instr('sdfsdf@sina.com', '@')+1) from dual; SUBSTR('SDFSDF@SINA.COM',INSTR ------------------------------ sina.com
sql截取字符串
最新推荐文章于 2023-12-28 12:42:29 发布