Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Help Me Please, Im trying to search for a certain string that may be present in one or all columns of a table
Thanks ! TurkBear
Ill give it a try
Cheers Raymie
"TurkBear" <noone_at_nowhere.com> wrote in message
news:nafdmt0pslhh4fuom55d2o3igom2fs0ql2_at_4ax.com...
> 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 Wed Aug 01 2001 - 05:52:03 CDT
![]() |
![]() |