Re: ORA-00907

Try
decode (A,0,C,B/A)

• Harri

"James O'Brian" <jb300000456666_at_yahoo.com> wrote in news:a8ag3n$71e$1_at_slb2.atl.mindspring.net:

> 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.

-- 
-----------------------------------------------------------------------
Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4