17,086
社区成员
发帖
与我相关
我的任务
分享
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
select replace(replace('1,2,3,4,10,20,,30,,,40,,,,50',',,,',','),',,',',') from dual
这样好像很笨,从最多连续的逗号串开始嵌套替换select regexp_replace('1,2,3,4,10,20,,30,,,40,,,,50 ', '(,)+', ',') from dual;