Little trick -- Function Index || Conditional Unique
	文章来源: gaobd 于 2010-01-28 15:16:37

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