Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A Question on UPPERCASE/LOWERCASE INDEXES
yes:
create table tablename (
fieldname char(10),
field2 char(2)
);
create index indexname on tablename (upper(fieldname));
it runĀ“s under Oracle Received on Wed May 14 1997 - 00:00:00 CDT