How to resolve ORA-01747 Error Message in Oracle database

Learn the cause and how to get to the bottom of the ORA-01747 error message in Oracle.

Description

When you encounter an ORA-01747 error, the following error message will appear:

ORA-01747: invalid user.table.column, table.column, or columns specification

Cause

You tried to reference a column name, however the column name used is a reserved word in Oracle.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

Try redefining your table so that none of your column names are reserved words.

Option #2

Try enclosing the reserved word in double quotes.

For example, if you had a provider table with a column named number, and you tried to replace this discipline as follows:

UPDATE suppliers
SET number = 10000;

You would receive the following error message:

You may want to right this error by enclosing the column name in double charges as follows:

UPDATE suppliers
SET "number" = 10000;