Find Number of Occurrences of a Character in a String in Oracle

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

Use Regexp_Count function in Oracle to count the number of occurrences of a string in Oracle using SQL. Below is the example to count the number of occurrences of Comma in a string.

Syntax: RegExp_Count(String, CharacterToFindOccurrences)

SELECT REGEXP_COUNT ('abc, skm, 23, a,,', ',') FROM DUAL

You will get the result 5.

number of occurrences of a character in a string in Oracle