Hi,
I am having a problem usign (+) with decode.
here is my code
I would like to get all SQL.radioaddress, but I am not sure where to add (+) sign in the decode statement.Code:WHERE SQL.radioaddress = DECODE(greatest(rac.radioaddress, 20000000), 20000000, to_char(rac.radioaddress), BBLG.CONVERSION.to_hex(rac.radioaddress))
Any ideas?
Thanks
Roman




Reply With Quote