select REGEXP_SUBSTR(c630000036,'000000000004775') from t157
REGEXP_SUBSTR() 检索匹配的字符串
eg: select REGEXP_SUBSTR('000000000004770;000000000004772;000000000004817;000000000004775;','000000000004775') from dual ;
select REGEXP_SUBSTR(c630000036,'000000000004775') from t157
REGEXP_SUBSTR() 检索匹配的字符串
eg: select REGEXP_SUBSTR('000000000004770;000000000004772;000000000004817;000000000004775;','000000000004775') from dual ;