see error in query ORA-01476: divisor is equal to zero [message #183473] |
Fri, 21 July 2006 02:20  |
mfa786
Messages: 210 Registered: February 2006 Location: karachi
|
Senior Member |
|
|
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
|
|
|
|
|