【oracle建表时字段使用了关键字】请问这样的咋建表呢？

Question

首先，我是直接从一个已经建好的表查出建表语句来直接建表的，但是会提示标识符无效ORA-00904: : invalid identifier

求助how to解决，谢谢

建表语句如下：

-- Create table
create table CHK_DATA_CIRCULT_ROUTE
(
id CHAR(24) not null,
circuit_code VARCHAR2(80),
route_serial_no VARCHAR2(80),
route_network_type VARCHAR2(80),
trans_circuit_name VARCHAR2(80),
circuit_international_position VARCHAR2(80),
take_timeslot VARCHAR2(80),
device_port_code VARCHAR2(80),
timeslot_position VARCHAR2(80),
comment VARCHAR2(80),
batch_code VARCHAR2(80),
vail_desc VARCHAR2(2500),
vail_status VARCHAR2(80),
time_stamp TIMESTAMP(6) default SYSDATE,
is_unique VARCHAR2(80),
is_check VARCHAR2(80)
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255;

Answer 1

修改comment，避免和关键字冲突比如f_comment

如果一定要用这个名字，那就加双引号，如下：




CREATE TABLE CHK_DATA_CIRCULT_ROUTE
(
  ID                             CHAR(24) NOT NULL,
  CIRCUIT_CODE                   VARCHAR2(80),
  ROUTE_SERIAL_NO                VARCHAR2(80),
  ROUTE_NETWORK_TYPE             VARCHAR2(80),
  TRANS_CIRCUIT_NAME             VARCHAR2(80),
  CIRCUIT_INTERNATIONAL_POSITION VARCHAR2(80),
  TAKE_TIMESLOT                  VARCHAR2(80),
  DEVICE_PORT_CODE               VARCHAR2(80),
  TIMESLOT_POSITION              VARCHAR2(80),
  "COMMENT"                        VARCHAR2(80),
  BATCH_CODE                     VARCHAR2(80),
  VAIL_DESC                      VARCHAR2(2500),
  VAIL_STATUS                    VARCHAR2(80),
  TIME_STAMP                     TIMESTAMP(6) DEFAULT SYSDATE,
  IS_UNIQUE                      VARCHAR2(80),
  IS_CHECK                       VARCHAR2(80)
)