How to search all objects for text string
Hello.
Does SQL Developer have a way to search all db objects (tables, views, procs, etc) for a text string? I want to look for a certain string, such as 'ADDR_NO', and see what tables and views have that string in a field name, and what packages use that string, etc. In other tools I've used there have been handy functions to do that.
Or do I just need to write a query?
Thanks,
Paul