RE: function based index help ??

From: Mark Moynahan <Mark.Moynahan_at_apollogrp.edu>
Date: Tue, 08 Jul 2003 17:06:15 -0700
Message-ID: <F001.005C3EA5.20030708165927@fatcity.com>

Here's a link from AskTom that goes into good detail on what you want to accomplish. He also demonstrates how to use concatenated function based indexes which I think what you're looking for. Even though his example is based upon NULLS you can easily modify his code to work for you.

http://tinyurl.com/gdfo

Mark Moynahan

-----Original Message-----
Sent: Tuesday, July 08, 2003 2:09 PM
To: Multiple recipients of list ORACLE-L

Hi all,

I have a table like this, both cols are Nullable.

SQL> desc test
Name Type

--------- STATUS CHAR(1) (could be A or D) ID NUMBER

I'd like to build a unique index on column ID when the status='A', how to create this function based index?

Thank you!

Janet

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Janet Linsy
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mark Moynahan
INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------