Isnull Problem

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • SHASHANKSHARMA
    New Member
    • Feb 2008
    • 1
    #1

    Isnull Problem

    Dear All,

    I am facing a problem after migration DB from SQL to ORACLE.
    There is a function ISNULL() supported by SQL but in ORACLE it is NVL().
    But is there any way to use ISNULL in ORACLE without changing it's to NVL.
    Please guide me or is there any DATA TYPE available in ORACLE that support all other data types(exp. char,varchar2,n umber date,etc...)
    Tags: oracle isnull
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      You can store char,varchar2,n umber, date into varchar2 field.

        Comment

        • amitpatel66
          Recognized Expert Top Contributor
          • Mar 2007
          • 2358
          #3
          Originally posted by SHASHANKSHARMA
          Dear All,

          I am facing a problem after migration DB from SQL to ORACLE.
          There is a function ISNULL() supported by SQL but in ORACLE it is NVL().
          But is there any way to use ISNULL in ORACLE without changing it's to NVL.
          Please guide me or is there any DATA TYPE available in ORACLE that support all other data types(exp. char,varchar2,n umber date,etc...)
          I am not able to understand what exactly your requirement is?

          How would you use a function that is not there in oracle?
          ISNULL is not a standard function in oracle but rou can create one user defined function if you wish to.

            Comment

            Previous template Next
            Working...