Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index on partial field?
No
Barbara Hiles <BEH_at_csd.uwm.edu> wrote in article
<BEH.727.0098F6FE_at_csd.uwm.edu>...
> 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 Wed Jan 29 1997 - 00:00:00 CST