|ORA-01476:||divisor is equal to zero|
|Cause:||An expression attempted to divide by zero.|
|Action:||Correct the expression, then retry the operation.
|Posts about ORA-01476|
WISH YOU ALL A VERY HAPPY NEW YR.
To find the buffer hit ratio when I executed the following query its giving
me one error "
ERROR at line 4
ORA-01476 divisor is equSelect from V$SGA_TARGET_ADVICE fails on Oracle 10.2 for Linux.
The error reported is about division by zero
SQL > select * from v$sga_target_advice
select * from v$sga_target_advice
Are you sure it ran successfully? I got error on a 9206 database on W2000.
SQL > set linesize 132
SQL > set pagesize 100
SQL > break on query
SQL > column query format a50 wHandling nulls consistently is specified in the "rules. " (Ted Codd 's 12
(which are really 13 if you count zero))
Specification of a value for "some error happened along the way so I don 't
know wI agree Niyi -- just to add my two cents
the SQL language is missing/lacking functionality to implement this
in relational algebra "(R WHERE P) WHERE Q " is logically equivalent with "R
Because if you do not have a when-others the error is automatically raised... You DON 'T NEED the
SQL > declare
2 x number
4 x 1 / 0
|Oracle Database Server Error Codes|