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 --------------------------------------------------------------------- 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).
