表A BM
2100TT12-0016
2103LG11-0215
2103E00-0089
求一SQL语句将'-'去除
结果如下 BM
2100TT120016
2103LG110215
2103E000089
2100TT12-0016
2103LG11-0215
2103E00-0089
求一SQL语句将'-'去除
结果如下 BM
2100TT120016
2103LG110215
2103E000089
SELECT REPLACE(BM,'_','')FROM TAB;
做个小例子吧 你仿照着就行了
SQL> select name from t1;NAME
--------------------
21TT-98
33WT-95SQL> select replace(name,'-') from t1;REPLACE(NAME,'-')
--------------------
21TT98
33WT95