Oracle截取某字段之后的所有字符串
例如:
原字段:
要求效果:850283013
SQL如下:
select substr(d1.medical_record_no,
instr(d1.medical_record_no, '_') + 1,
length(medical_record_no) )
from db_payment d1 where d1.medical_record_no='6101251042130010179_850283013';