SELECT regexp_replace( a,'</?[^>]*>|nbsp;|&','') a from dual 转载于:https://www.cnblogs.com/lansetuerqi/p/9895436.html