Update col to Y set all other to N in trigger.
From: Ethan Post <post.ethan_at_gmail.com>
Date: Thu, 30 Jan 2020 17:51:25 -0600
Message-ID: <CAMNhnU0AoTyvCTr6nMb-EK0agw6z1mZbEaWrcruSHOOomHsupg_at_mail.gmail.com>
I should recall how to do this but been a while.
_at_poststop
Date: Thu, 30 Jan 2020 17:51:25 -0600
Message-ID: <CAMNhnU0AoTyvCTr6nMb-EK0agw6z1mZbEaWrcruSHOOomHsupg_at_mail.gmail.com>
I should recall how to do this but been a while.
I need the best way to
update foo set col='Y' where pk=1;
And have a trigger automatically...
update foo set col='N' where pk !=1;
While avoid mutating table error.
This one seems hard to google the answer to.
Thanks,
Ethan
e-t-h-a-n.com
_at_poststop
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 31 2020 - 00:51:25 CET