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

posted on 2014-04-10 00:24  sangbiao  阅读(268)  评论(0编辑  收藏  举报