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   sangbiao  阅读(269)  评论(0编辑  收藏  举报

努力加载评论中...
点击右上角即可分享
微信分享提示