ORA-00936: missing expression

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、解决办法

原文地址:https://www.cnblogs.com/hzcya1995/p/13314815.html