The 'Find database objects' tool is one I use often, especially because I'm new to the database at my current work. One feature I would love to see added is that the results would also list the line(s) of the objects matching your search pattern, and - assuming the tool already uses a query on sys.dba_source - the line of code where that match is found (possibly highlighting the match).
Above I talk of 'line(s)' (plural) cause in the current situation the results list the packages or other objects only once when a match is found.
A little sidestep - but not completely irrelevant - from the IDE towards PL/SQL: anyone knows of performance issues with regexp_like when compared to 'ordinary' like clauses?
This question is relevant because of the possibility to query with regexp in the aforementioned tool; using it might put a heavy load on your db if the performance issue exists.
Above I talk of 'line(s)' (plural) cause in the current situation the results list the packages or other objects only once when a match is found.
A little sidestep - but not completely irrelevant - from the IDE towards PL/SQL: anyone knows of performance issues with regexp_like when compared to 'ordinary' like clauses?
This question is relevant because of the possibility to query with regexp in the aforementioned tool; using it might put a heavy load on your db if the performance issue exists.
