Oracle SQL - REGEXP_LIKE function

Requirements

Here is the table

Demo

SQL>
SQL> drop table history;

Table dropped.--  w w w. j a v  a 2 s .  c  om

SQL> create table history(
  2  comments   VARCHAR2(60)) ;
SQL>
SQL> insert into history values ('this is a test');
SQL> insert into history values ('salary reduction this is a test');
SQL> insert into history values ('this is a test this is a test Transfer to sales department');
SQL> insert into history values ('Not a great trainer; this is a test this is a test this is a test!');
SQL> insert into history values ('Senior sales this is a test this is a test this is a test?');
SQL> insert into history values ('Turns out to be slightly disappointing this is a test this is a test');
SQL> insert into history values ('Transfer to human resources; salary raise this is a test');
SQL> insert into history values ('Salary reduction 550 this is a test this is a test');
SQL> insert into history values ('Founder and first employee of the company');
SQL> insert into history values ('Accounting established this is a test this is a test');
SQL> insert into history values ('Project for the ACCOUNTING department this is a test');
SQL>

Write SQL to use the regexp_like function to search for words.

Use {n,} to express "at least n times."

Demo

SQL>
SQL> select comments
  2  from   history
  3  where  regexp_like(comments, '([^ ]+ ){8,}');

COMMENTS-- from   w  w w  . ja  va2s.c om
------------------------------------------------------------
this is a test this is a test Transfer to sales department
Senior sales this is a test this is a test this is a test?
Transfer to human resources; salary raise this is a test
Salary reduction 550 this is a test this is a test
Accounting established this is a test this is a test
Project for the ACCOUNTING department this is a test

6 rows selected.

SQL>