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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Experts plese help me..

Re: Experts plese help me..

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: Thu, 18 Nov 1999 15:01:33 -0600
Message-ID: <69D459B31CC60921.5C9CD856921DAE02.6F6D8B63AD8065F6@lp.airnews.net>


Darren,

I think Norazman is saying that his table contains too many records for a linear search to be practical, and wants instead a presumably faster SQL search. I am guessing that he needs to perform this search interactively, so searching all 50,000,000 (or however many) records might take too long. I further speculate that if the string is not found in any record, then he needs to return some sort of NOTFOUND flag, whereupon some alternative action is taken.

If these assumptions are correct, I propose this SQL statement:

select * from the_table where the_column like '%CP%';

Well, Norazman, what do you think?

Paul Cluiss
Dallas, Texas

Darren Brock wrote:

> One way that you can do this is with a cursor. Loop through all the
> records and for each one, check to see if it contains CP# and if it
> does, perform a select and substring out the part that you want stuffing
> appropriate info into a temp table.
>
> Darren
>
> Norazman wrote:
> >
> > Hi all,
> > I have a description field which user use to enter some description.
> > However due to bad design (from the earlier designer), I need a way of
> > how I can figure this out.
> >
> > This field can contains any words but usually it was also use to key in
> > some Capital number.
> > It might be something like this:
> >
> > CP#4599 ACERPOWER 4100, 64MB SDRAM DIMM(upgradable to 384MB)
> >
> > However, I'm only interested on the Capital number not the nonsense
> > word.
> > Normally the format (the way usr keyed) in is 'CP% 999999'.
> >
> > The problem is, the numbers of record is so huge that I don't want to go
> > through it 1 by 1.
> > How can I do a SQL to return only whatever from this field that sounds
> > like 'CP% 999999' and if nothing match just
> > return N/A or whatever to indicate the search string is not exist.
> >
> > So far I can say around 65-70% of the field have this string.
> >
> > Thanks for your help.
> >
> > Azman
>
> --
> ***********************************************
> Darren Brock Oracle Developer/DBA
> Governet
> 208-522-1225
> brock_at_governet.net
> ***********************************************
Received on Thu Nov 18 1999 - 15:01:33 CST

Original text of this message

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