oracle 截取字符串

select case  when length(yh_id)>3 then concat(substr(yh_id,1,3),'...') else yh_id end as yh_id,yhmc from gis_qx_yhb where rownum<10