摘要: select name ,REGEXP_REPLACE(str,"[\\[\"\\]]",'') from ( select trans_array(1, ",", name,list) as (name,str) from ( select '经办人' as name,'["1001","1002"]' as list ) ... 阅读全文
posted @ 2019-05-30 11:28 chenzechao 阅读(3918) 评论(0) 推荐(0)