delete

Search for string in view definitions

Sometime it happens that you need to search definitions of the views for some string. Problem is that Oracle 9 works badly with texts bigger then 32KB. Try this script: DECLARE xSearchStr varchar2(100) := '...here_some_string_without_%...'; CURSOR listOfViews is select OWNER, VIEW_NAME, TEXT_LENGTH from all_views --where owner in (...here list of owners....) --if you need to limit owners ; xowner       varchar2(50); xview_name   varchar2(50); xtext_length number; xtext        all_views.text%type; textView clob; begin open listOfViews; loop fetch listOfViews into xowner,...