查询状态在1,2,5,7的记录-oracle

　　

select t.returnedgoods
from t_logicom_service t
where
instr(',1,2,5,7,',','||t.returnedgoods||',')>0;