Oracle数据库现象:
SQL> select * from v$version;
BANNER--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> create table a(table int);
create table a(table int)
*
ERROR at line 1:
ORA-00904: : invalid identifier
SQL> create table a(column int);
create table a(column int)
*
ERROR at line 1:
ORA-00904: : invalid identifier
Oracle中使用关键字作为列名时,字段需加双引号:
SQL> create table a("column" int);
Table created.
++++++++++++++