I've been spoiled a bit by using Quest's Sql*Navigator.

I've been trying to wean myself away from that and onto ORacle's pl/sql
developer but there's one function I havent found (or its plain not there).

Every once in a while it would be nice to search over all stored
procedure (all stand alones, package definitions and package bodies,
maybe triggers too) searching for some string.

I *think* I got pl/sql dev to search over a given procedure body but
searching accross procedures has so far eluded me.

Is there a way to do it (Well, yeah I could search in the dictionary
table of user_source natively, but I mean a neat way through the gui) or
am I out of luck?

Any favorite free or cheap ( <= $100 ) tools to recommend ?

Lee wrote:
SELECT DISTINCT owner, name, type, line
FROM all_source
WHERE text LIKE '%<your_search_string>%';

The tool I prefer is free: SQL*Plus.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan wrote:
Well yes, free (as in beer) is good, I rejoice in the use of free or
nearly free tools.

But it really does seem as if you have to actually be in edit mode for a
particular procedure, package, etc in order to get at the little Sql*Dev
text search box at the upper left of the edit screen; and that there's
no tricksy key combo or menu choices that lets us search globally over
all the code.

Its not the end of the world, since we can always search the source
views as you point out. but there's no denying thats a minor drawback.


Now I understand that there's merit in knowing how to do things oneself
without the aid of the electronic monkeys. I was a boy scout. I actually
can light a fire with nothing but vi.

On the other hand, there are times when we care a bit less about
building character, and just want to build the bloody procedures, and in
those cases, a power assist a la Toad or Sql*Nav or All Round automatins
pl/whatsis come in handy.

Oracle is on record as wanting Pl/Dev to be the "toad killer". Close,
but no cigar.