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: <bdbafh_at_gmail.com>
Date: 19 Dec 2005 10:32:33 -0800
Message-ID: <1135017153.555051.9220@g47g2000cwa.googlegroups.com> 





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 - 12:32:33 CST












Original text of this message













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