oracle query
-
hi friends... is there any replacement for the following query select 0/0 from dual; if i execute the query i am getting error ORA-01476. can any body helps me in bye mahen
-
hi friends... is there any replacement for the following query select 0/0 from dual; if i execute the query i am getting error ORA-01476. can any body helps me in bye mahen
hi Its a mathematical error..in a division divisor cannnot be Zero. Regards Joe
-
hi Its a mathematical error..in a division divisor cannnot be Zero. Regards Joe
thanks jo instead of error if it gives some value.. i can assign that to variable and get the value.. i working with one programme..say variable a and b. some time variable b might be zero.. when i run the query.. say select a/b then it gives the error if thats values become 0.. please help.. me thanks mahen
-
thanks jo instead of error if it gives some value.. i can assign that to variable and get the value.. i working with one programme..say variable a and b. some time variable b might be zero.. when i run the query.. say select a/b then it gives the error if thats values become 0.. please help.. me thanks mahen
hi you can use DECODE function with which you can replace 0 with some other value. Regards Joe