What is the best regular expression to satisfy need:
1) input string must be integer, minimal value is 0, maximal value is 100, no other symbols are allowed in string, no commas no spaces.
Example data:
with T as
(select '-1' str from dual --not ok
union
select '0' str from dual --ok
union
select '1' str from dual --ok
union
select '100' str from dua --ok
union
select '1000' str from dual-- --not ok
union
select '101' str from dual --not ok
union
select '10.1' str from dual --not ok
union
select '10,1' str from dual --not ok
union
select 'a' str from dual --not ok)
select * from T
where regexp_like(str,'^[[:digit:]]{0,3}$');