Re: COALESCE does short circuit - NOT
From: Dom Brooks <dombrooks_at_hotmail.com>
Date: Thu, 19 Jan 2012 16:01:08 +0000
Message-ID: <BLU0-SMTP14956DCA10A3EF2C857B99AA1860_at_phx.gbl>
Date: Thu, 19 Jan 2012 16:01:08 +0000
Message-ID: <BLU0-SMTP14956DCA10A3EF2C857B99AA1860_at_phx.gbl>
There is an ORA-02287 check which prevents you from using a sub select, i.e. (SELECT seq_test.nextval FROM DUAL), in the same situation although you can use other subselects obviously.
I'd guess it's a bug and both methods should either be disallowed or allowed (disallowed I'd say based on similar restrictions on sequence usage).
Cheers,
Dominic
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 19 2012 - 10:01:08 CST