Looking for a SQL query in ORACLE that returns the count of all the special characters used in a particular column. Suppose in a column there are 5 rows and each uses two special characters. I am looking for some query that gives 10 as the result.
What I used is:
SELECT * FROM Customers WHERE REGEXP_LIKE(Employees, '[^]^A-Z^a-z^0-9^[^.^{^}^ ]' );
but it seems to not be working.
Tried a lot over the net but no luck.
Update: looking for a solution with 10g