Re: Search for a string a database

gustave 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....?
>
> Thank's a lot

No. You need to know the table name and the field name.

Do the following:

SELECT table_name, column_name
FROM user_tab_columns
WHERE data_type IN ('VARCHAR2', 'CHAR')
AND data_length >= the_length_of_your_search_string;

That will give you a list to work from.

Daniel Morgan Received on Wed Nov 27 2002 - 12:52:32 CST