1、创建测试表,
create table test_replace(id number, value varchar2(20));
2、插入测试数据
insert into test_replace values(1,'1yy');
insert into test_replace values(2,'1yy');
insert into test_replace values(3,'2xx');
insert into test_replace values(4,'3ss');
insert into test_replace values(5,'4bbb');
3、查询表中所有记录数,select t.*, rowid from test_replace t,
4、编写sql,实现替换功能,select t.*, replace(value,'1yy','1y') value2 from test_replace t,