Or, for more flexibility, you can use the Oracle R...
# suiteanalytics
s
Or, for more flexibility, you can use the Oracle REGEXP_LIKE function to allow use of regular expressions:
CASE WHEN REGEXP_LIKE({text_field}, '[[:space:]]+') THEN 1 ELSE 0 END
However, this will match all strings with a whitespace character, which would include tabs, new lines, etc. as well as spaces. It depends upon what kind of spaces you are looking for.