RE: Logical duplicates
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Fri, 28 Jun 2013 12:36:26 +0400
Message-ID: <OFDCD256D3.27627B27-ON44257B98.002EC4F3-44257B98.002F4817_at_psbank.ru>
May be would be better to create unique index, like "create unique index IXXX on XXX(greatest(nvl(a,b),nvl(b,a)),least(a,b))" Best regards,
Sayan Malakshinov
http://orasql.org
Date: Fri, 28 Jun 2013 12:36:26 +0400
Message-ID: <OFDCD256D3.27627B27-ON44257B98.002EC4F3-44257B98.002F4817_at_psbank.ru>
May be would be better to create unique index, like "create unique index IXXX on XXX(greatest(nvl(a,b),nvl(b,a)),least(a,b))" Best regards,
Sayan Malakshinov
http://orasql.org
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 28 2013 - 10:36:26 CEST