-
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
Last edited by tamilselvan; 08-06-2004 at 02:33 PM.
-
Maybe here:
Code:
WHERE SQL.radioaddress =
DECODE(greatest(rac.radioaddress(+), 20000000)
, 20000000, to_char(rac.radioaddress(+))
, BBLG.CONVERSION.to_hex(rac.radioaddress(+)))
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
What error did you get after adding (+)?
Tamil
-
That worked
Thank you
Roman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|