ORACLE中replace用法

select * from DB;

update DB set 节点性质 = '三通' where 节点性质 ='3T';

update DB set 节点性质 = replace(节点性质,'4T','四通');

 

posted @ 2022-09-07 16:35  ZLL1135145973  阅读(140)  评论(0)    收藏  举报