// Oracle error reference

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
Error message
invalid user.table.column, table.column, or column specification

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, SIZE or another reserved word, unquoted.
  • A trailing comma or dot in a column list, as in SET a = 1, WHERE.

How to fix it

  1. 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;
  2. Check the reserved words list in V$RESERVED_WORDS when naming columns.

    SELECT keyword FROM v$reserved_words WHERE reserved = 'Y' ORDER BY keyword;

Related errors

More syntax and sql statements 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.