Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PRAGMA AUTONOMOUS_TRANSACTION in a trigger

Re: PRAGMA AUTONOMOUS_TRANSACTION in a trigger

From: <ak_tiredofspam_at_yahoo.com>
Date: 4 Apr 2005 10:51:55 -0700
Message-ID: <1112637115.704627.200770@g14g2000cwa.googlegroups.com>


>> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US