ijswalker
11-20-2007, 07:32 PM
Hi,
I am trying to write a decode function and I want to say "if the column 1 contains 100 in row 5 and the column 2 contains the word CAT then return the amount in column 6.
If I remember rightly the decode function would have a || in it somewhere but I can't remember. Can someone help. I am querying an Oracle database using SQL.
Thanks
Ian
I am trying to write a decode function and I want to say "if the column 1 contains 100 in row 5 and the column 2 contains the word CAT then return the amount in column 6.
If I remember rightly the decode function would have a || in it somewhere but I can't remember. Can someone help. I am querying an Oracle database using SQL.
Thanks
Ian