举例 :需要从PD2001_A_1.13.15 中截取后面的1.13.15
select reverse (substr (reverse ('PD2001_A_1.13.15') , 0 , instr( reverse ('PD2001_A_1.13.15' ),'_')-1))
select reverse(split(reverse('PD2001_A_1.13.15'),'_')[0])
结果:1.13.15
举例 :需要从PD2001_A_1.13.15 中截取后面的1.13.15
select reverse (substr (reverse ('PD2001_A_1.13.15') , 0 , instr( reverse ('PD2001_A_1.13.15' ),'_')-1))
select reverse(split(reverse('PD2001_A_1.13.15'),'_')[0])
结果:1.13.15