Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    8

    Unanswered: please help me with this

    Somebody that has knowledge of ORACLE, could say if a similar function exists to the NVL, to make something similar to the following thing in DB2:

    select nvl(tipo,0) from table

    thank you for your help

    Sincerely

    Rubén Troche

    P.D.Have a nice day!!!

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: please help me with this

    Try this...

    select value(tipo,0) from table
    or
    select coalesce(tipo,0) from table

    dollar


    Originally posted by cytrus
    Somebody that has knowledge of ORACLE, could say if a similar function exists to the NVL, to make something similar to the following thing in DB2:

    select nvl(tipo,0) from table

    thank you for your help

    Sincerely

    Rubén Troche

    P.D.Have a nice day!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •