Re: Update problems ...
From: Joe Nardone <joe_at_access1.digex.net>
Date: 1995/07/27
Message-ID: <3v71bl$oth_at_news4.digex.net>#1/1
Date: 1995/07/27
Message-ID: <3v71bl$oth_at_news4.digex.net>#1/1
jack (jalford_at_immcms1.redstone.army.mil) wrote:
: ERROR at line 1:
: update ammo set serial_number= rtrim(serial_number)
: where serial_number != rtrim(serial_number);
: ORA-00001: unique constraint (AMMO.PRIMARY_KEY_AMMO) violated
How about
SELECT RTRIM(SERIAL_NUMBER), COUNT(RTRIM(SERIAL_NUMBER)) K
FROM AMMO
GROUP BY SERIAL_NUMBER
ORDER BY K DESC;
to give you a list of serial numbers; any that are duplicates
will be listed first.
Joe
-- =------------------------------------------------------------------------= Joe Nardone | joe_at_access.digex.net |Received on Thu Jul 27 1995 - 00:00:00 CEST