// Oracle error reference

ORA-01476: divisor is equal to zero

An expression divided a number by zero. Guard the divisor with NULLIF or CASE so a zero gives NULL or a default instead.

Error code
ORA-01476
Category
Data values and conversion
Error message
divisor is equal to zero

What it means

ORA-01476 is raised when a numeric expression divides by zero. Note that a query can fail on rows you didn't expect, since Oracle may evaluate the expression for rows before applying every filter.

Common causes

  • Ratios or percentages over rows where the total is zero.
  • A divisor column that allows zero or a default of 0.

How to fix it

  1. Turn a zero divisor into NULL.

    SELECT clicks / NULLIF(impressions, 0) AS ctr FROM ad_stats;
  2. Or return a default with CASE.

    SELECT CASE WHEN impressions = 0 THEN 0 ELSE clicks / impressions END AS ctr FROM ad_stats;

Related errors

More data values and conversion errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

Work on Oracle in SQLly

A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.