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: A Question on UPPERCASE/LOWERCASE INDEXES

Re: A Question on UPPERCASE/LOWERCASE INDEXES

From: RJSchulzSJ <rjschulzsj_at_aol.com>
Date: 1997/05/14
Message-ID: <19970514223000.SAA12235@ladder02.news.aol.com>#1/1

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

Original text of this message

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