方法1:
select substr('123456789',length('123456789')-6+1,6) from dual;
方法2:
SELECT name, RIGHT(certid,4) as certid
FROM mjsxd_newuser_day