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
Hi all,
I have a table like this, both cols are Nullable.
SQL> desc test
Name Type
- -
STATUSCHAR(1) (could be A or D)
IDNUMBER
I'd like to build a unique index on column ID when the
status='A', how to create this function bas