Include whitespace in Regular Expression of Oracle sql

Viewed 32

I have a regex written for not accepting Alphanumeric values in a column. Query:

SELECT * FROM users where not REGEXP_LIKE (first_Name, '^[0-9a-zA-Z]+$')

This query is returning me values containing whitespaces too. I don't want to include strings containing whitespaces in my resultset. Can I please get a modified query?

enter image description here

0 Answers
Related