oracle query?

Ajit Gunge · 06-21-2012, 09:49 AM

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,

Didier Spaier · 06-22-2012, 03:50 AM

See here.

dgodbey · 07-19-2012, 04:55 PM

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.