ORA-00907

Try to do:
if A not equal to zero, then divide B by A, else C.

decode(A<>0,B/A,C)

But gives:

decode(A<>0,B/A,C)

               *
ORA-00907: SQL missing right parenthesis

Your time will be appreciated. Thanks. Received on Mon Apr 01 2002 - 14:48:46 CST