Re: Search for a string a database

On 27 Nov 2002, cguyard_at_free.fr wrote:
> I need to search for a string in a oracle database but i don't
> know in which table this string is. I don't want to look all
> tables... Is there someone that can help me....?

Query the system tables for all string like datatypes, retrieving their table and column names. Slap the strings

    select column_name as grep_value
    from table_name
    union

around them. Then, slap "create view oragrep as" on top of that. Replace the final union with ";". Now, execute that SQL.

Then, execute the query,

select * from oragrep where grep_value = 'string';

-- 
Galen Boyer