Re: Search for text

hpuxrac wrote:
> Well not really you need to know what table and what column to search.
>
> Conceivably ( but a very bad idea ) on a unix system you could use a
> command such as grep to tear into the database files and look for a
> word.

You could run something like this:
SELECT 'select count(*) from '||table_Name||' WHERE '||

          column_name||' like ''%Toronto%''; '   from user_tab_cols

save it to a text file and run the output. If you're clever you could write a PL/Sql block to loop and run the generated SQL.

> Probably the best idea is to ask someone who does have access to the
> source code of the application and have them fix spelling mistakes or
> at least identify the process that you can use to suggest fixes to the
> content.

Agreed that this would be the better approach.

//Walt Received on Wed Feb 15 2006 - 12:13:05 CST