天天看点

oracle正则表达式

select SEQUENCE_NAME from ALL_SEQUENCES where regexp_like (sequence_name,'^SEQ'); mysql的like查询,不区分大小写,oracle的like区分大小写 SELECT * FROM my_table WHERE 1=1 AND regexp_like(name,'Selenium','i');