1、
regexp_like(name,’[ABC]’)
相当于（like ‘%A%’ or like ‘%B%’ or like ‘%C%’）;

2、测试

SQL> select * from t1;

NAME

A
B
C
D

SQL> select name from t1 where regexp_like(name,’[ABC]’);

NAME

A
B
C

SQL> select name from t1 where name like ‘%A%’ or name like ‘%B%’ or name like ‘%C%’;

NAME

A
B
C