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?
What version of Oracle?
If you're using Oracle 11.1 or later, you can use
In earlier versions, there are various less elegant options such as