这是关于一个缺少逗号或错位的约束子句。因为，按照你的说法，Oracle * 认为 * 你正在pay_due_date列上创建检查约束，它（Oracle）不会让你这样做，因为列检查约束不能引用其他列。
然而，如果你把它放在一个表级（第一个例子）或适当的列（第二个例子），那么它就像预期的那样工作。

SQL> CREATE TABLE crime_charges (
  2      charge_id     NUMBER(10)
  3          CONSTRAINT crime_charges_id_pk PRIMARY KEY,
  4      crime_id      NUMBER(9)
  5          CONSTRAINT crime_charges_crime_id_fk
  6              REFERENCES crimes ( crime_id ),
  7      crime_code    NUMBER(3)
  8          CONSTRAINT crime_charges_crime_code_fk
  9              REFERENCES crime_codes ( crime_code ),
 10      charge_status VARCHAR2(2),
 11      fine_amount   NUMBER(2),
 12      court_fee     NUMBER(7),
 13      amount_paid   NUMBER(7),
 14      pay_due_date  DATE,
 15      --
 16      CONSTRAINT charge_status_check CHECK ( charge_status IN ( 'PD', 'GL', 'NG' ) )
 17  );

Table created.

SQL> CREATE TABLE crime_charges (
  2      charge_id     NUMBER(10)
  3          CONSTRAINT crime_charges_id_pk PRIMARY KEY,
  4      crime_id      NUMBER(9)
  5          CONSTRAINT crime_charges_crime_id_fk
  6              REFERENCES crimes ( crime_id ),
  7      crime_code    NUMBER(3)
  8          CONSTRAINT crime_charges_crime_code_fk
  9              REFERENCES crime_codes ( crime_code ),
 10      charge_status VARCHAR2(2)
 11      CONSTRAINT charge_status_check CHECK ( charge_status IN ( 'PD', 'GL', 'NG' ) ),
 12      fine_amount   NUMBER(2),
 13      court_fee     NUMBER(7),
 14      amount_paid   NUMBER(7),
 15      pay_due_date  DATE
 16  );

Table created.