How to display those fields where one or two words?

Question

Oracle

You need to select only those data from the table where the field contains one or two words.
I tried to write in SELECT like this:
WHERE (NAME LIKE '__% __%');
but it displays and where are three words, etc.

Answer 1

If you need a bicycle, then "one or two words" means "the number of spaces (excluding leading and trailing) < 2" In general, Oracle has had REGEXP_LIKE
for such things since time immemorial .

Answer 2

Если считать количество пробелов, то будет так
WHERE len(replace(name, ' ', 'ZZ'))-len(name) <= 1