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: Help with sql query (select from a table using patter matching(%) )

Re: Help with sql query (select from a table using patter matching(%) )

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 19 Dec 2005 14:07:26 -0800
Message-ID: <1135030033.326932@jetspin.drizzle.com>


Jack wrote:

> Its 8.1.7 ... but no clue how to do it...
> 
> 
> bdbafh_at_gmail.com wrote:
> 

>>Consider using a function-based index that filters to only store the
>>last character of the string (as that is how you are apparently
>>filtering on the "END" of the table name).
>>
>>Of course, there is no version information regarding if you are stuck
>>back on Oracle 8.1.7 Standard edition - in which case a function-based
>>index will not be within the realm of features that are enabled ... in
>>which case you should look into upgrading.
>>
>>-bdbafh

http://www.psoug.org
click on Morgan's Library
click on Function Based Index

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Dec 19 2005 - 16:07:26 CST

Original text of this message

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