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_