Repeat Operator « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. Repeat Operator
1.A repeat operator: {}. Repeating the vowel match a second time
2.REGEXP_INSTR(description,'[aeiou]{2,3}'): Matches from two to three times
3.REGEXP_INSTR(description,'[aeiou]{3,5}'): Specify from three to five consecutive vowels
4.Repetition operator would say, 'at least m times' with {m,}