Oracleregexp_like相关知识
Oracle regexp_like的相关知识及使用示例是本文我们主要要介绍的内容,我们首先看一下Oracle中的支持正则表达式的函数,主要有下面四个: create table fzq id varchar(4),value varchar(10) --数据插入insert into fzq values('1','1234560');
insert into fzq values('2','1234560');
insert into fzq values('3','1b3b560');
insert into fzq values('4','abc');
insert into fzq values('5','abcde');
insert into fzq values('6','ADREasx');
insert into fzq values('7','123 45');
insert into fzq values('8','adc de');
insert into fzq values('9','adc,.de');
insert into fzq values('10','1B');
insert into fzq values('10','abcbvbnb');
insert into fzq values('11','11114560');
insert into fzq values('11','11124560');
select * from fzq where value like '1____60';
select * from fzq where regexp_like(value,'1…60');
select * from fzq where regexp_like(value,'1{4}60');
select * from fzq where regexp_like(value,'1[[:digit:]]{4}60');
select * from fzq where regexp_like(value,'^1');
select * from fzq where regexp_like(value,'[[:space:]]');
select * from fzq where regexp_like(value,'^(+|+)$');
select * from fzq where regexp_like(value,'[[:punct:]]');
create or replace
FUNCTION CheckName(NameStr in VARCHAR2)
RETURN integerAsBEGIN--符合返回1,
不符合返回0
if(NameStr is null or length(NameStr)
页:
[1]