ORA-00904 🗃️ SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

Seen on: SQL

Meaning

Oracle uppercases unquoted identifiers. Quoted lowercase names, typos, or using a SELECT alias in WHERE cause it.

Common causes

  • Typo
  • Column created with quotes and different case
  • Alias used in WHERE
  • Reserved word

⚡ Quick fix

  1. Use the exact uppercase name or matching quotes
  2. Use subqueries/CTEs for alias filtering

Detailed fix by platform

SQL

  1. SELECT column_name FROM all_tab_columns WHERE table_name = 'ORDERS';

How to diagnose

  1. Column — Exact name/case?
  2. Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.