1 Reply Latest reply: Feb 6, 2014 10:57 PM by dileraco RSS

Regular Expression: Oracle 11g

dileraco Explorer
Currently Being Moderated

Hi everyone,


I need to use a regex in my plsql code. However, I can't, although it is too easy. My data format should be mininum 5 and maximum up to 16 characters with only numbers [0-9].


My regex is;


select case when regexp_like('2400010243424', '^[0-9]{5, 16}$') then 'true' else 'falsee' end sonuc from dual


But it returns false


Can you help me?


Thank You


  • Correct Answers - 10 points
  • Helpful Answers - 5 points