Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whole database search?
yes -- I used to have a script running on a cron job to look for stuff
like that at night.
suppose your text is 5 characters long,
I'd spool to a file:
spool mystring.sql
select 'select distinct owner||'.'||table_name||'.'||column_name from
'|| owner||'.'||table_name ||' where '||column_name ||' = '||
''''your-string-in-question''''||';'
from all_tab_columns where
column_type like '%CHAR%' and column_length >= 5;
spool off
then run the spooled file:
spool mystring.lst
@mystring.sql
'select distinct owner||'.'||table_name||'.'||column_name from '||
Glynn Taylor wrote:
>
> Is it possible to search an entire Oracle database for a string of text? if
> so does anyone have a suitable procedure?
>
> Many Thanks
>
> Glynn
Received on Tue Nov 23 1999 - 23:08:34 CST