尝试重命名 oracle 表中带有空格的列时出错.错误 - SQL 错误:ORA-00946:缺少 TO 关键字 [英] Error trying to rename columns with space in oracle table. Error - SQL Error : ORA- 00946 : missing TO keyword

问题描述

我有一个名为 employee 的表.其中，我希望将列名从 Employee Name 更改为 Employee_Name(注意现有的列名有一个空格！)

I have table named employee. In which , I wish to alter the column name from Employee Name to Employee_Name (note that the existing column name has a space!)

当我使用以下命令时:

Alter table employee rename column Employee Name to Employee_Name

我收到此错误:

SQL 错误:ORA-00946:缺少 TO 关键字

SQL Error : ORA- 00946 : missing TO keyword

如何克服这个问题?

推荐答案

由于 Oracle 不知道空格是列名的一部分，因此您必须将其括在引号中以确保其正确识别:

Since Oracle doesn't know the space is part of the column name, you have to enclose it in quotes to make sure it recognizes it correctly:

Alter table employee rename column "Employee Name" to Employee_Name

这篇关于尝试重命名 oracle 表中带有空格的列时出错.错误 - SQL 错误:ORA-00946:缺少 TO 关键字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！