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: [URGENT] Case sensitive

Re: [URGENT] Case sensitive

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 17 Apr 2002 19:15:16 +0100 (BST)
Message-ID: <0Ju*T72lp@news.chiark.greenend.org.uk>


Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote:
>2) create a function based index on the column and query using the function.
>this is an 8iEE or higher option only.

I see that Doc ID 161556.1 seems to indicate that function based indexes will be in SE from 9.2, which is excellent news, and should do away with any excuse for hideous uppercase columns.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Wed Apr 17 2002 - 13:15:16 CDT

Original text of this message

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