摘要: 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 阅读全文
posted @ 2011-03-29 15:30 柠檬绿松 阅读(146) 评论(0) 推荐(0) 编辑
View Code