1、错误描述

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as [email protected]
 
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>

3、解决办法