Re: COALESCE does short circuit - NOT
- From: Dom Brooks <dombrooks@xxxxxxxxxxx>
- To: "uwe@xxxxxxxxxxxx" <uwe@xxxxxxxxxxxx>
- Date: Thu, 19 Jan 2012 16:01:08 +0000
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
Other related posts: