# ORA-00904: "X": invalid identifier

**Code:** `ORA-00904` · **Category:** SQL · **Seen on:** SQL

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

## 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.

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/ora-00904-invalid-identifier)
