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: Jack <amitkr.3_at_gmail.com>
Date: 19 Dec 2005 11:53:47 -0800
Message-ID: <1135022027.752872.303720@g43g2000cwa.googlegroups.com>


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
Received on Mon Dec 19 2005 - 13:53:47 CST

Original text of this message

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