Decode And Outer Join

Hi,

I am having a problem usign (+) with decode.

here is my code

Code:

---

WHERE SQL.radioaddress =
      DECODE(greatest(rac.radioaddress, 20000000), 20000000,
            to_char(rac.radioaddress),
            BBLG.CONVERSION.to_hex(rac.radioaddress))

---

I would like to get all SQL.radioaddress, but I am not sure where to add (+) sign in the decode statement.

Any ideas?

Thanks

Roman

Maybe here:

Code:

---

WHERE SQL.radioaddress =
DECODE(greatest(rac.radioaddress(+), 20000000)
, 20000000, to_char(rac.radioaddress(+))
, BBLG.CONVERSION.to_hex(rac.radioaddress(+)))

---

:rolleyes:

What error did you get after adding (+)?

Tamil

That worked

Thank you

Roman