Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Whole database search?

Re: Whole database search?

From: Rachel Rainey <raineyr_at_cuug.ab.ca>
Date: Wed, 24 Nov 1999 05:08:34 GMT
Message-ID: <383B724A.BFC4A0EC@cuug.ab.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US