Is is possible to count the number of occurrences of a character in a VARCHAR in oracle? Something that would allow me to determine '11001110' has 5 ones?
Oracle SQL count occurances of character in VARCHAR
oraclevarchar
Related Question
- Determine Oracle session client character set
- Oracle Tablespace – Managing Character Set
- Sql-server – varchar performance impact
- Concept of Cardinalilty in Oracle
- Oracle Regex – Using REGEXP_LIKE with Square Brackets Inside Character Set
- MySQL – Space Occupied by VARCHAR UTF-8 Column
- Oracle equivalent to MS-Access character range/set
- SQL count by n-tuples
Best Answer
What version of Oracle?
If you're using Oracle 11.1 or later, you can use
REGEXP_COUNT
In earlier versions, there are various less elegant options such as