XMLWordPrintableJSON

Details

    Description

      nvl2(x,y,z)
      Returns the second argument if the first argument is not null, otherwise it returns the third argument.
      nvl2 is short hand for the case expression “case when x is not null then y else z end.”

      References:
      http://docs.oracle.com/database/122/SQLRF/NVL2.htm#SQLRF00685

      Attachments

        Activity

          People

            thundergun Vincent Tran
            grahn Greg Rahn
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: