Modifying a constraint to make exceptions...

Drop your CONSTRAINT uniqueCar and

use a unique function based index:

CREATE UNIQUE INDEX CAR_UIDX_01
    ON CAR(DECODE(model,NULL,NULL,MAKE),DECODE(model,NULL,NULL,MODEL))

Cheers and greetings from Spain.

Carlos. Received on Thu Jan 13 2005 - 02:39:51 CST