If you need to find some text, that is used in some View of your Oracle Database. You can use the code below.
CREATE TABLE TEMP_VIEWS_SOURCE (
view_name VARCHAR2(30),
text CLOB
);
BEGIN
FOR v IN (SELECT view_name, text FROM user_views) LOOP
INSERT INTO TEMP_VIEWS_
