SCOTT@orcl> CREATE OR REPLACE VIEW test_view AS SELECT 'ABC' AS test_col FROM DUAL
  2  /

View created.

SCOTT@orcl> CREATE OR REPLACE VIEW test_view2 AS SELECT 'DEF' AS test_col FROM DUAL
  2  /

View created.

SCOTT@orcl> CREATE OR REPLACE VIEW test_view3 AS SELECT 'ABCABC' AS test_col FROM DUAL
  2  /

View created.

SCOTT@orcl> BEGIN
  2    FOR r IN
  3  	 (SELECT DBMS_METADATA.GET_DDL
  4  		    (object_type => 'VIEW', name => view_name, schema => USER)
  5  		    AS view_text
  6  	  FROM	 USER_VIEWS)
  7    LOOP
  8  	 IF INSTR (r.view_text, 'ABC') > 0 THEN
  9  	   DBMS_OUTPUT.PUT_LINE (r.view_text);
 10  	 END IF;
 11    END LOOP;
 12  END;
 13  /

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "SCOTT"."TEST_VIEW3" ("TEST_COL") AS

  SELECT 'ABCABC' AS test_col FROM DUAL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "SCOTT"."TEST_VIEW" ("TEST_COL") AS

  SELECT 'ABC' AS test_col FROM DUAL

PL/SQL procedure successfully completed.