Re: Help Me Please, Im trying to search for a certain string that may be present in one or all columns of a table

Use Pl/Sql and
open a cursor with the desired columns and then loop thrum the table testing each column; Tedious, but once written, it should go fairly quickly - assuming a not too huge table..

I don't know any other way...

"Raymond Craig" <raymond.craig_at_baesystems.com> wrote:

>I have been asked to search a database table for a number string that some
>users have populated inserted the information into the wrong field.
>
>Is there a way of searching all the columns in the table for the required
>string.
>
>%11230%
>
>The original column is a Varchar2 10
>
>I have whittled down the columns (205 in said table) using the
>dba_table_columns view down to about 100
>
>
>Thanks in Advance
>
>Raymond Craig
>CSC DBA
>
>
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Jul 31 2001 - 09:17:50 CDT