//截取下划线后的字符串
select substr('GY_272',instr('GY_272', '_', -1, 1)+1) from dual
select substr('GY_272',instr('GY_56', '_', -1, 1)+1) from dual
zmztya 2018-09-11 13:54 原文
//截取下划线后的字符串
select substr('GY_272',instr('GY_272', '_', -1, 1)+1) from dual
select substr('GY_272',instr('GY_56', '_', -1, 1)+1) from dual