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>


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-l
Received on Thu Jan 19 2012 - 10:01:08 CST

Original text of this message