以下都能返回结果
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard+.s')
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard..s')
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard....s')
select 1 from dual where REGEXP_LIKE ('harddisks', '^hard+.s')
但是以下无法返回。
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard.s')
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard...s')
select 1 from dual where REGEXP_LIKE ('harddisks', '^hard+.s$')
请高手解释
[ 本帖最后由 taylorgao 于 2010-9-26 20:20 编辑 ]
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard+.s')
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard..s')
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard....s')
select 1 from dual where REGEXP_LIKE ('harddisks', '^hard+.s')
但是以下无法返回。
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard.s')
select 1 from dual where REGEXP_LIKE ('harddisks', 'hard...s')
select 1 from dual where REGEXP_LIKE ('harddisks', '^hard+.s$')
请高手解释
[ 本帖最后由 taylorgao 于 2010-9-26 20:20 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/88933/viewspace-675662/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/88933/viewspace-675662/