NVL function with arguments of different data types

  • From: francis zziwa <fzziwa@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 4 Jul 2010 23:45:44 +0300

Hi listmates,
Is the NVL  function applicable when the arguments supplied are of different
types. e.g nvl(x1,x2) where x1 is an integer and x2 is a character.
And in a situation where one of the arguments cannot be converted to another
type.
Any help will be appreciated.

~~~~~~~~~~
regards,
Francis

Other related posts: