oracle query?
 

Hi All,
This question is Oracle related.
I have couple of tables in the databases.I dont know which table has the value that I am intrested in, it can either be a coloum name or it can be a value in some coloum of the table in the database.
Now I want to exact table and the database.That has this particular attribute/value.Is there a grep like functionality or an command in sql which I can be used to search the database.Please let me know?

Thanks,

See here.

Everything in Oracle lives in a table. And they call the whole tamale the data dictionary.

So, you can find a lot looking around at the dictionary. If you are dba, the following query brings back quite a bit.

select table_name from dictionary;

The tables live in tabs. There is all ALL_TABLES or USER_TABLES.
Then the columns. Table name COLS

DESC COLS
DESC TABS

Play around a bit. Let me know if you need more.