Hi, It is here.
http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/functions120.htm#i91806 >If expr2 is character data, then Oracle Database converts expr3 to the data >type of expr2 before returning a value unless expr3 is a null constant. In >that case, a data type conversion is not necessary, and the database returns >VARCHAR2 in the character set of expr2. (but NVL2 returns CLOB not VARCHAR2, if expr2 is CLOB.) litailang 2011/5/18 Thomas Mueller <[email protected]>: > Hi, > > It sounds a bit like a hack. I would rather not add this feature, > unless this is the officially documented behavior of Oracle. > > Could you provide a link to the Oracle documentation where this is described? > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google Groups "H2 > Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
