Regular expression help for matching numbers
ash0602Aug 6 2010 — edited Aug 6 2010Hi,
I want a exact match of either 9 digits or 12 digits, my query should give "No Match Found" as the input value is actually 10 digit
select case when regexp_like(regexp_replace( ' 123 4567 890', ' ' ), '^([0-9]{9})|([0-9]{12})$')
then 'Match Found'
else 'No Match Found'
end as test
from dual;
Need help, as I must be doing something very basic thing, wrong.
Regards,
Ash