All Source, refers to ALL_SOURCE - which only stores pl/sql code.
Today, the search feature doesn't include View source as a search level.
Is this something that can be added in future as it seems a little odd that I cannot search the source code of views - please don't make me use TOAD its so bloated and slow compared to SQL Dev!!
View source is stored in a LONG column, which doesn't make it readily avail for query searches.
However, we could search the dependency views to find objects that are required for a view. So say, if you're looking for views that query EMP - we could make the search show that. But searching the raw LONG source of views for 'random' text, not so likely to happen.
Would the dependency chain search cover most of your use cases?
My main requirement is to search for tables and columns used by views, so if the above covers this then that would be great thanks...
tables yes, column no - but if you know what table the column is in, then you're there
Perhaps you already have scripts similar to this one, which prompts for a column name or pattern (use percent sign as a wildcard) and lists views referencing it.
select c.column_name, c.table_name, c.owner
from all_tab_columns c, all_objects o
where o.object_type = 'VIEW'
and o.object_name = c.table_name
and o.owner = c.owner
and c.column_name like UPPER('&Column_Search_Pattern')
order by c.column_name, c.table_name, c.owner;
Storing such scripts as code snippets or user-defined reports would be a viable workaround while awaiting potential enhancements to Find.
To find all views referencing a specific table, open the table from the Connections navigator and check its Dependencies tab.
SQL Developer Team
Hi, thanks for the sql.
Like I said I can also use TOAD for detailed searching, but will obviously continue with SQL Developer to all other stuff as its soooooo much better!!
Thats great thanks for the responses.