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

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

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

From: Raymond Craig <raymond.craig_at_baesystems.com>
Date: Wed, 1 Aug 2001 11:52:03 +0100
Message-ID: <3b67dd16$1@pull.gecm.com>

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

Original text of this message

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