ITPub博客

REGEXP_LIKEREGEXP_SUBSTRREGEXP_INSTRREGEXP_REPLACE[@more@]====================REGEXP_LIKE====================SQL> select * from t1; COL1 COL2---------- ---------- 1 fly 2 flying 3 swim 4 Fly 5 Flies SQL> select * from t1 where regexp_like(col2, 'fl(y(ing)?|(ies))'); COL1 COL2---------- ---------- 1 fly 2 flying--'i' => 不区分大小写 SQL> select * from t1 where regexp_like(col2, 'fl(y(ing)?|(ies))','i')