字段名与关键字冲突如何解决

Question

SQL> CREATE TABLE TEST
  2  ("SELECT" VARCHAR2(10));表已创建。SQL> SELECT "SELECT" FROM TEST;未选定行

Answer 1

select "comment" from codepiece

Answer 2

SQL> select "comment" from codepiece;
select "comment" from codepiece
       *
ERROR 位于第 1 行:
ORA-00904: 无效列名

Answer 3

SQL> desc codepiece;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- --------------
 CODEPIECE_ID                              NOT NULL NUMBER(38)
 CATEGORY1_ID                                       NUMBER(38)
 CATEGORY2_ID                                       NUMBER(38)
 NAME                                      NOT NULL VARCHAR2(256)
 SUMMARY                                            VARCHAR2(4000)
 CODE                                               LONG
 MODIFYDATE                                         DATE
 COMMENT                                            VARCHAR2(2000)
 AUTHOR                                             VARCHAR2(64)
 REFERENCE                                          VARCHAR2(256)

Answer 4

select "COMMENT" from codepiece;

Answer 5

select "comment" from codepiece; 不行
select "COMMENT" from codepiece; 可以！居然还分大小写，服了ORA。