We can see all view database object in oracle. We can use something like this to see all view object:

select * from all_views

You can add the filter if you want to find more specifically. See the code below

select * from all_views where view_name like '%yourkeyword%'

But if we want to search something like string or keyword in views code we can’t do query like the following :

select * from all_views where text like '%yourkeyword%'

The query will cause an error because the data type of text column is long. This is the reason why finding a view become a separate discussion.

The solution is to create a procedure as follows :

begin
for i in (select * from all_views)
loop
if(i.text like %keyword%) then
dbms_output.put_line(i.view_name);
end if;
end loop;
end;

Don’t forget to turn on dbms_output !

Comments RSS feed