Re: IF-like function in Oracle?

To answer your question you can do just about anything in sqlplus, the only question is how ugly will it get.

To be a bit more specific, you still use the decode for char data, but need to use greatest/least rather than sign. something like
decode(greatest(A,B),A,val1,val2)
would return val1 if A>=B val2 if B > A

Craig Sivils Received on Fri Sep 29 1995 - 00:00:00 CET