CREATE TABLE NAME_DATA_TBL
(
  NAME_ID             NUMBER(9) NOT NULL,
  LAST_BUSINESS_NAME  VARCHAR2(60 BYTE),
  FIRST_NAME          VARCHAR2(32 BYTE),
  MIDDLE_INITIAL      VARCHAR2(32 BYTE),
  NAME_TITLE          VARCHAR2(5 BYTE),
  NAME_SUFFIX         CHAR(12 BYTE),
  ADDITIONAL_TITLE    VARCHAR2(60 BYTE),
  NAME_FORMAT         CHAR(1 BYTE),
  CONV_RUN_NO         NUMBER(3)
);

SQL> SELECT /*+ parallel(a,12) */ COUNT (*) FROM NAME_DATA;

  COUNT(*)
----------
 290371372

CREATE TABLE BAD_WORDS
(
  X_VALUE  VARCHAR2(255 BYTE)
);

SQL> select count(*) from BAD_WORDS;

  COUNT(*)
----------
       547

SELECT A.rowid row_id, A.*
  FROM NAME_DATA_TBL A, BAD_WORDS B
 WHERE UPPER (
             TRIM (A.FIRST_NAME)
          || TRIM (A.MIDDLE_INITIAL)
          || TRIM (A.LAST_BUSINESS_NAME)) LIKE
          '%' || B.X_VALUE || '%'
       OR UPPER (
                TRIM (A.LAST_BUSINESS_NAME)
             || TRIM (A.MIDDLE_INITIAL)
             || TRIM (A.FIRST_NAME)) LIKE
             '%' || B.X_VALUE || '%'
       OR UPPER (TRIM (A.LAST_BUSINESS_NAME) || TRIM (A.FIRST_NAME)) LIKE
             '%' || B.X_VALUE || '%'
       OR UPPER (TRIM (A.FIRST_NAME)) LIKE '%' || B.X_VALUE || '%'
       OR UPPER (TRIM (A.LAST_BUSINESS_NAME)) LIKE '%' || B.X_VALUE || '%'
       OR UPPER (TRIM (A.MIDDLE_INITIAL)) LIKE '%' || B.X_VALUE || '%'
       OR UPPER (TRIM (A.FIRST_NAME) || TRIM (A.LAST_BUSINESS_NAME)) LIKE
             '%' || B.X_VALUE || '%';

CREATE OR REPLACE
  TRIGGER NO_SWEARING
  BEFORE INSERT
      OR UPDATE
  ON NAME_DATA_TBL
  FOR EACH ROW
  DECLARE
      v_cnt NUMBER;
  BEGIN
      SELECT  COUNT(*)
        FROM  BAD_WORDS
        WHERE ROWNUM = 1
          AND (
                  INSTR(
                        UPPER(
                              RTRIM(:NEW.FIRST_NAME) || TRIM(:NEW.MIDDLE_INITIAL) || LTRIM(:NEW.LAST_BUSINESS_NAME)
                             ),
                        X_VALUE
                       ) > 0
               OR
                  INSTR(
                        UPPER(
                              RTRIM(:NEW.LAST_BUSINESS_NAME) || TRIM(:NEW.MIDDLE_INITIAL) || LTRIM(:NEW.FIRST_NAME)
                             ),
                        X_VALUE
                       ) > 0
               OR
                  INSTR(
                        UPPER(
                              RTRIM(:NEW.LAST_BUSINESS_NAME) || LTRIM(:NEW.FIRST_NAME)
                             ),
                        X_VALUE
                       ) > 0
               OR
                  INSTR(
                        UPPER(:NEW.FIRST_NAME),
                        X_VALUE
                       ) > 0
               OR
                  INSTR(
                        UPPER(:NEW.LAST_BUSINESS_NAME),
                        X_VALUE
                       ) > 0
               OR
                  INSTR(
                        UPPER(:NEW.MIDDLE_INITIAL),
                        X_VALUE
                       ) > 0
               OR
                  INSTR(
                        UPPER(
                              RTRIM(:NEW.FIRST_NAME) || LTRIM(:NEW.LAST_BUSINESS_NAME)
                             ),
                        X_VALUE
                       ) > 0
              );
      RAISE_APPLICATION_ERROR(
                              -20500,
                              'Watch your language!'
                             );
END;
/

BEGIN
  DBMS_ERRLOG.CREATE_ERROR_LOG(dml_table_name => 'NAME_DATA_TBL');
END;
/
UPDATE NAME_DATA_TBL
   SET FIRST_NAME = FIRST_NAME
   LOG ERRORS INTO ERR$_NAME_DATA_TBL('VALIDATE') REJECT LIMIT UNLIMITED
/