ORA-01747: invalid user.table.column specification
A column name in the statement is badly formed, most often because it is a reserved word such as DATE, LEVEL or COMMENT used without quotes.
- Error code
ORA-01747- Category
- Syntax and SQL statements
What it means
ORA-01747 means a column reference doesn't follow the user.table.column form Oracle expects, typically because a reserved word was used as a column name.
Newer releases name it: invalid column specification: column_name.
Common causes
- A column called
DATE,LEVEL,COMMENT,SIZEor another reserved word, unquoted. - A trailing comma or dot in a column list, as in
SET a = 1, WHERE.
How to fix it
-
Quote reserved-word columns exactly as created (usually upper case), or rename them.
UPDATE events SET "COMMENT" = 'checked' WHERE id = 1; ALTER TABLE events RENAME COLUMN "COMMENT" TO note;
-
Check the reserved words list in
V$RESERVED_WORDSwhen naming columns.SELECT keyword FROM v$reserved_words WHERE reserved = 'Y' ORDER BY keyword;
Related errors
More syntax and sql statements errors
ORA-00936missing expressionORA-00907missing right parenthesisORA-00911invalid characterORA-00917missing commaORA-00918column ambiguously definedORA-00923FROM keyword not found where expectedORA-00937not a single-group group functionORA-00979not a GROUP BY expression
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
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.