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

Re: Index on partial field?

From: Fleming <fleming_at_hal-pc.org>
Date: 1997/01/29
Message-ID: <01bc0d96$6f579ec0$96a1dece@fleming.hal-pc.org>#1/1

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

Original text of this message

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