orcl中replace()用法: replace:(字元串 | 列):進行替換; 將bqh1表中name列帶“小”的字改成“大”: select * from bqh1select a.*,replace(name,'小','大') from bqh1 a ...
orcl中replace()用法:
replace:(字元串 | 列):進行替換;
將bqh1表中name列帶“小”的字改成“大”:
select * from bqh1
select a.*,replace(name,'小','大') from bqh1 a