FIND WORDS IN DATABASE

[Carlos Sérgio]

Good morning people !

I need to locate a certain word within objects of an Oracle database. Could anyone help me about it, please?

Thanks to all,

Carlos Sergio
Carlosergio631@yahoo.com.br

[dr_gori]

You can search for all_source

See this SELECT:

Select all

select * 
from all_source 
where upper(text) like '%SELECT%'

is searching for all rows that has the word SELECT at the base.

[Carlos Sérgio]

Thank you very much brother! Thanks for the tip !

A hug!

Carlos

[Carlos Sérgio]

For me to locate a word within oracle b.dado objects, the command worked perfectly. However in Trigger's it was not found. Will I have to hold other commands to track trigger's codes? Could you answer me, please?

[dr_gori]

At all_source has the triggers as well.
See example:

Select all

SQL> select DISTINCT TYPE 
  2  from user_source 
  3  / 
 
TYPE 
------------ 
FUNCTION 
PACKAGE 
PACKAGE BODY 
PROCEDURE 
TRIGGER 
 
SQL>  

Remember that all_source shows everything you have privileges to look at your user ... If you want to look all over the bank, you must do SELECT on DBA_SOURCE. (Obviously, you need a DBA privilege to access these tables)

: -O

[Carlos Sérgio]

Thanks Brother ....

Valeu!

A great and happy New Year!