ORA-00904: & quot; T1 & quot;. & quot; AREA_ID & quot;: Invalid identifier, ora-00904area_id

ORA-00904: "T1". "AREA_ID": Invalid identifier, ora-00904area_id

1. Error description

ORA-00904: "T1". "AREA_ID": Invalid identifier

00904. 00000-"% s: invalid identifier"

* Cause

* Action

An error occurred while listing 45 columns and 8 columns in the row.

2. Error cause

When splicing an SQL statement, "AREA_ID" is not queried, and "AREA_ID" is not found in group"

3. Solution

When splicing an SQL statement, add AREA_ID and group by AREA_ID to the select statement.

The ORA-00904: identifier is invalid when oracle creates a table

You have used the reserved characters "size" and "rows" of oracle, which cannot be used as column names. Change them to other words, such as "items_size" and "items_rows". Otherwise, it will be difficult to call them in the future.

Oracle problem ORA-00904: Invalid identifier

The corresponding field does not exist in the database table, so the identifier is invalid.