Re: pl/sql developer question

From: Lee <>
Date: Wed, 05 Dec 2007 12:33:26 -0500
Message-ID: <fj6nde$au6$>

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. Received on Wed Dec 05 2007 - 18:33:26 CET

Original text of this message