ТЕМА:

declare

  cursor c_views is

    select owner,view_name,text from dba_views;

  v_owner varchar2(30);

  v_view  varchar2(30);

  v_text  varchar2(32000);



begin

  open c_views;

  loop

  fetch c_views into v_owner,v_view,v_text;

   exit when  c_views%notfound ;

    if upper(v_text) like '%TP_ID_CCONVERT%' then

         dbms_output.put_line(v_owner||'.'||v_view);

    end if;      

  end loop;

  close c_views;

end;

create or replace function view_instr(p_owner varchar2,p_name varchar2,p_string varchar2) return number is
v_text varchar2(32000);
begin
select text into v_text from all_views where owner=p_owner and view_name=p_name;
return instr(v_text,p_string);
end;
/

select view_name from all_views where view_instr(owner,view_name,'тра-ля-ля')>0;