1、创建测试表,
create table test_string(value varchar2(50));
2、插入测试数据
insert into test_string values('abcdefg');
insert into test_string values('99jsdfsyn');
insert into test_string values('fsfdsa9176d');
insert into test_string values('fda7kgj3');
insert into test_string values('fa8mchd65');
commit;
3、查询表中全量数据,select t.*, rowid from test_string t;
4、编写sql,去掉string最后一个字符; select t.*, substr(value,1,length(value)-1) value2 from test_string t;