Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PRAGMA AUTONOMOUS_TRANSACTION in a trigger
>> It only needs to be unique when jobtype = 'RES'. Other jobtypes are
allowed to have duplicates. <<
in this case I'd suggest a function based UNIQUE index on (CASE WHEN jobtype = 'RES' THEN STREETNAME ELSE NULL END, and so on for 3 other columns Received on Mon Apr 04 2005 - 12:51:55 CDT