In software development will probably have a lot of changes that we do not want. These changes might have occurred because there are the wrong code, a change from the buyer or the software for the enhancement when the maintenance. This will be very inconvenient if this change causes a change in the code.
The first thing that maybe we should do is look for codes that is affected by the change. This will be very difficult for us if the code we’ve created is very much at all.
For the following I will give tips if the changes that occur in oracle database.
If changes occur within the database object such as package, function, trigger, procedure or java source we can select the following directions
select * from all_source where text like '%yourkeyword%'
maybe we can filter them out again because everything in there including objects from the system as well.
select * from all_source where owner = 'USEROWNER' and text like '%keyword%'
we can make it more specific, for example we want to find that there is only procedure
select * from all_source where owner = 'USEROWNER' and type = 'PROCEDURE' and text like '%keyword%'
Until here may be a little tips that may help in the search for a string in the oracle database objects.
| 
| 
| 
| 
| 
| 
