SQL & PL/SQL

Hi.

First, sorry for my poor English.

I use Oracle Database 10g v 10.2.0.2.0.

I detect something (I think it's a bug) in function REGEXP_LIKE. I validate an email address with the next script. The results are not that I expected.

---
declare
email varchar2(128):= 'user@mail.com';
begin

if REGEXP_LIKE(email, '^[http://A-Z0-9._%-]+@[http://A-Z0-9._%-]+\.[A-Z|http://forums.oracle.com/forums/]{2,4}$') then
dbms_output.put_line('OK!');
else
dbms_output.put_line('NOP!');
end if;
end;
---

If email contains the char 'z' lowercase then REGEXP_LIKE eval to false but any other lowercase letters eval to true. If I add the 3rd parameter modifier case insensitive ('i') then eval to true with any lowercase letter.

It's a bug or I'm doing something bad?

Thanks!

Edited by: user10232115 on 16/10/2008 03:50