1 Reply Latest reply: Jan 6, 2013 12:18 AM by O.Developer RSS

    NVL Function

    Moazam Shareef
      Guyz,

      how can i use NVL Function with the below code, anyone add nvl with the below query.
      FLOOR(MONTHS_BETWEEN(SYSDATE,:CTRL.JOIN_DATE))/12+
      FLOOR(MONTHS_BETWEEN(SYSDATE,:BLOCK25.EFF_DATE))/12
      Using forms 6i and oracle 9i

      Edited by: Moazam Shareef on Jan 5, 2013 10:13 PM