ORA-00907：缺少右括号 [英] ORA-00907: missing right parenthesis

问题描述

SQL> CREATE TABLE STUDENT
  2  (SNO NUMBER(6),
  3  SNAME VARCHAR2(10) CONSTRAINT SNAME_NN NOT NULL,
  4  COURSE CHAR(10),
  5  FEE NUMBER(10) CONSTRAINT FEE_NN NOT NULL,
  6  DOB DATE CONSTRAINT DOB_NN NOT NULL,
  7  CONSTRAINT SNO_PK PRIMARY KEY(SNO),
  8  CONSTRAINT SNAME_CK CHECK(SNAME=UPPER(SNAME)),
  9  CONSTRAINT COURSE_CK CHECK(COURSE='JAVA','ORACLE','.NET')),
 10  CONSTRAINT FEE_CK CHECK(FEE>500));
CONSTRAINT COURSE_CK CHECK(COURSE='JAVA','ORACLE','.NET'))

请帮帮我。



谢谢你。

please help me.

thank u.

推荐答案

检查约束检查多个值应该有IN运算符



尝试：

The check constraints checking multiple values should have IN operator

Try:

CREATE TABLE STUDENT (
  SNO NUMBER(6),
  SNAME VARCHAR2(10) CONSTRAINT SNAME_NN NOT NULL,
  COURSE CHAR(10),
  FEE NUMBER(10) CONSTRAINT FEE_NN NOT NULL,
  DOB DATE CONSTRAINT DOB_NN NOT NULL,
  CONSTRAINT SNO_PK PRIMARY KEY(SNO),
  CONSTRAINT SNAME_CK CHECK(SNAME=UPPER(SNAME)),
  CONSTRAINT COURSE_CK CHECK(COURSE IN('JAVA','ORACLE','.NET')),
  CONSTRAINT FEE_CK CHECK(FEE>500)
);

这篇关于ORA-00907：缺少右括号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！