在IBM出版的一本红皮书中,好像是DB2开发人员指南,当时是DB2 V6,现在都9了还有这个函数,不建议value而已,用coalesce.因为后者是标准而已。From DB2 Developer's guide by Craig S Mullins:The VALUE function is a synonym for the COALESCE function. Favour using COALESCE ...
显示全部在IBM出版的一本红皮书中,好像是DB2开发人员指南,当时是DB2 V6,现在都9了还有这个函数,不建议value而已,用coalesce.因为后者是标准而已。
From DB2 Developer's guide by Craig S Mullins:
The VALUE function is a synonym for the COALESCE function. Favour using COALESCE though as it adheres to the ANSI standard.
收起