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

Legend

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