The solution to the problem of quot;ORA-01747: user.table.column, table.column or invalid column description & quot; in Oracle database

In this issue, the editor will bring you the solution of "ORA-01747: user.table.column, table.column or invalid column description" in the Oracle database. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

The solution to the error "ORA-01747: user.table.column, table.column or invalid column description"

Today, I encountered the error situation of "ORA-01747: user.table.column, table.column or invalid column description" in the project. I checked that it was caused by the bad column name of the database, and the name used the keyword of the database.

If there are many columns and it is difficult to determine which column name uses the keyword, the following suggestions can be used for reference:

I use the following methods to locate

Select *

From v$reserved_words

Where keyword

In (

Select COLUMN_NAME

From all_tab_columns

Where table_name = 'table name uppercase' and owner=' user name uppercase'

);

When creating tables in the Oracle database, we cannot use some words

Because there are some things that Oracle has already used.

Such as "row". If you use it, you will report an error.

How to judge:

My method: copy the faulty sql directly into the query and run

You can also look at the color directly. The keyword will change color. I just used the keyword "row", so I made a mistake.

The above is the solution to the error "ORA-01747: user.table.column, table.column or invalid column description" in the Oracle database shared by the editor. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.