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