Shulou(Shulou.com)06/01 Report--

Oracle"ORA-00904" error: Why is the identifier invalid? This problem may be our daily study or work often see. I hope you learned something from this question. The following is the reference content brought to you by Xiaobian. Let's take a look together!

1. The field name or table name is written incorrectly. Check it carefully. If there is no mistake, it may be the second case.

The second case is: your field contains Oracle keywords, try to enclose the error field in double quotes

Let me give you an example from today:

sql1：

insert into SSQX_SURGERY_INFO (ID, PackId, REMARK, DEPARTID, AMOUNT, PRIORITY)

values (3, 11, '1rt', 1, 1, 'fdg') keep reporting PackId is an invalid identifier

sql2：

insert into SSQX_SURGERY_INFO (ID, "PackId", REMARK, DEPARTID, AMOUNT, PRIORITY)

values (3, 11, '1rt', 1, 1, 'fdg') is OK, PackId is the keyword in oracle

Note: Oracle12 can execute SQL1, Oracle11 cannot.

Thank you for reading! After reading the above content, do you roughly understand the reason for oracle"ORA-00904" error: invalid identifier? I hope the content of this article is helpful to everyone. If you want to know more about related articles, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.