Little trick -- Function Index || Conditional Unique

Using Function Index To Enforce Conditional Unique On Multiple Columns


CREATE UNIQUE INDEX ON SUBSTR (DECODE (STATUS,1,TEAMID||'/'JOB,NULL),1,110);       

For details, see below:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1249800833250