Re: two schemas and running a diff on stored procedures

On 5 Aug 2005 05:38:28 -0700, "JR" <jriker1_at_yahoo.com> wrote:

>Let's say I have two schemas in a database. Both with the same stored
>procedures however one had some updates made to it. Is there an easy
>way to see what the differences are between the two schemas as far as
>the stored procedures without taking them one at a time and doing a
>diff in a text editing tool? THanks.
>
>JR

One could of course try to run a minus

select line, text
from dba_source
where owner=...
and name=...
minus
select line, text
from dba_source
where owner = ...
and name = ...

But better use proper source code control to prevent hunting the wumpus.

--
Sybrand Bakker, Senior Oracle DBA