oracle 字符串返回匹配的结果值

例

select substr(substr(c630000036,instr(c630000036,'000000000004775'),length(c630000036)),0,length(substr(c630000036,instr(c630000036,'000000000004775'),length(c630000036)))-1) aa from t157
where c630000036 =(select c630000036  from t157 where instr(c630000036,'000000000004775')>0)

instr(c630000036,'000000000004775')

用instr 函数c630000036字段中查找'000000000004775'，如果c630000036里面的值存在则返回 下标值

substr(c630000036,instr(c630000036,'000000000004775'),length(c630000036)) 

substr 截取字符串，在c630000036值里面截取，从instr(c630000036,'000000000004775')开始，length(c630000036) 结束位置

这样就能获取到想要的是什么勒