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

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

              Dates

              • Created:
                Updated:
                Resolved: