error in query ORA-01476: divisor is equal to zero

[mfa786]

sir i user this query but system give me error

SELECT STUSECMTAMT.totdebit/STUSECMTAMT.totalcr,STUJOURNAL.cre_bal/(STUSECMTAMT.totdebit/STUSECMTAMT.totalcr) FROM STUSECMTAMT,STUDEG,STUJOURNAL WHERE STUSECMTAMT.vhno=STUJOURNAL.ref_no AND STUSECMTAMT.studegid=STUDEG.studegid;

error


ERROR at line 1:
ORA-01476: divisor is equal to zero


please give me idea

thank

aamir

[ahmadbilal]

nvl(colname,1) will solve your problem

[admin]

Zero devisor error comes when you are deviding with 0 like 25/0. The best way is to remove division "/" from the query and see the data and you will find zero's. thanks