Code searching isn’t new for version 4.2. It’s not even new for version 4.1, or v4.0…but what IS new, is that some folks consider the SQL behind their VIEW objects to be ‘code.’
So, for version 4.2, you can say, search my PL/SQL source AND search the SQL behind my views.
You’ll notice there’s an option to add wildcards around your search term for the ‘Code’ category – that’s useful when searching object names in your data dictionary and also for references to that object in your source code.
Hit ‘Go’, and voila.
It’s not exactly easy to search on views, the code behind a view is stored in a LONG column. But, it’s not impossible.
You can see how we do it by using the Statements panel.
Don’t forget the ‘Trick!’
My favorite way to access the search.