天天看點

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');