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 -> Index on partial field?

Index on partial field?

From: Barbara Hiles <BEH_at_csd.uwm.edu>
Date: 1997/01/28
Message-ID: <BEH.727.0098F6FE@csd.uwm.edu>#1/1 







Is it possible to create an index using part of a field?
For example:  9 character ssn.


I need an index on last 4 first 5.


Can I do this if I've defined a 9 char ssn field?  (and if so - how?  substr?)



tia - barb.
Received on Tue Jan 28 1997 - 00:00:00 CST












Original text of this message













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