ORA-00936: missing expression

时间:2023-12-27 14:47:13

1、错误描述

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as scott@ORCL

SQL> create table XSB
  2  (
  3     XH char(6) NOT NULL PRIMARY KEY,
  4     XM char(8) NOT NULL,
  5     XB char(2) DEFAULT NOT NULL,
  6     CSSJ date NOT NULL,
  7     ZY char(2) NULL,
  8     ZXF number(2) NULL,
  9     BZ varchar(200) NULL
 10  );

create table XSB
(
   XH char(6) NOT NULL PRIMARY KEY,
   XM char(8) NOT NULL,
   XB char(2) DEFAULT NOT NULL,
   CSSJ date NOT NULL,
   ZY char(2) NULL,
   ZXF number(2) NULL,
   BZ varchar(200) NULL
)

ORA-00936: missing expression

SQL> 

2、错误原因

3、解决办法