ORACLE中相当于LIKE IN

1、使用正则表达式方式

SELECT T.*,ROWID FROM T
WHERE F_YEAR = '2018' AND REGEXP_LIKE(F_SSXM,'^(1t|2t|3t)')

2、使用 START WITH CONNECT BY PRIOR 方式

SELECT DISTINCT F_ID
  FROM BF_PROJECT
 START WITH ',010001009001001,001002066012,001002066013,' LIKE
            '%,' || F_ID || ',%'
CONNECT BY PRIOR F_PARENT = F_ID