Oracle：处理名为COMMENT的字段(Oracle: Handling a field named COMMENT)

Oracle：处理名为COMMENT的字段(Oracle: Handling a field named COMMENT)

我有一个名为COMMENT的字段的表，它似乎是一个保留字。

使用SQLDeveloper，如果我尝试：

select [COMMENT], another_field FROM table_created_by_idiot_developer

我明白了

SQL Error: ORA-00936: missing expression

如何在SQL Developer中的select中访问此字段？ （这是SQL Developer的问题，还是应该在oracle中将字段命名为COMMENT？）

I have a table with a field named COMMENT, which appears to be a reserved word.

Using SQLDeveloper, if I try:

select [COMMENT], another_field FROM table_created_by_idiot_developer

I get

SQL Error: ORA-00936: missing expression

How can I access this field in my select in SQL Developer? (Is this a problem with SQL Developer, or should field not be named COMMENT in oracle?)

最满意答案

尝试"COMMENT"而不是[COMMENT] 。 这是各种DBMS通常接受的替代语法。 我使用这种语法来引用SQLite中名称中包含点或UTF8字符的列。

Try "COMMENT" instead of [COMMENT]. This is alternate syntax commonly accepted by various DBMSes. I have used this syntax to refer to columns having dots or UTF8 characters in their names in SQLite.