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

Written by Vinish Kapoor

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.

April 26, 2023
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.

You Might Also Like

5 SQL Queries Every Oracle DBA Needs

Oracle Select Top 10 Records

5 Oracle Create Sequence Examples