DA Morgan wrote:
> Lee wrote:
>
>> 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 ?
>
>
> SELECT DISTINCT owner, name, type, line
> FROM all_source
> WHERE text LIKE '%<your_search_string>%';
>
> The tool I prefer is free: SQL*Plus.
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.
|
