search for a column value in all tables of a schema [message #420251] |
Thu, 27 August 2009 15:57  |
muralimadhavuni
Messages: 26 Registered: November 2005 Location: HYD
|
Junior Member |
|
|
Hi Experts,
I have 2 questions.
1. I need to search for a column value in all the tables of a schema.
2. search for a value in entire schema (including all the objects)
Example:
1. I need to search for a column value like "TELEMOBILE" in all the columns of all the tables.
2. I need to search for a value like "TELEMOBILE" in all the objects (including tables, procedures, packages, synonyms, etc...) of entire schema
Help would be more appreciated.
Thanks in advance
Murali
|
|
|
|
|
|
|
|
|
Re: search for a column value in all tables of a schema [message #420476 is a reply to message #420270] |
Sun, 30 August 2009 09:55   |
muralimadhavuni
Messages: 26 Registered: November 2005 Location: HYD
|
Junior Member |
|
|
Thanks for you reply.
Michel Cadot,
DBA_TAB_COLUMNS dictionary view will only display number of columns and its type which are the part of the table. It will not display the values of each column of each row. so, this will not solve my purpose. And the same thing is applicable for DBA_SOURCE, DBA_SYNONYMS dictionary views also.
But, i will "find_string" function in AskTom site.
sen_sam86,
user_col_comments will only display the comments of the column, but it will not display the values of each row of each column. so, this will not solve my purpose.
My intention is to find a string (in my example "TELEMOBILE") through out the database where ever it is used.
Hope you all understand my requirement now.
I appreciate for your responses.
Regards
Murali
|
|
|
|
|
|
|