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: