CREATE TABLE A1 (
JOBID NUMBER (19) NOT NULL,
JOBNAME VARCHAR2 (27) CONSTRAINT CCC NOT NULL,
SALARY NUMBER)
TABLESPACE W
;
CREATE TABLE A3 (
JOBID NUMBER (19) NOT NULL,
SALARY NUMBER)
TABLESPACE W
中间加一个;不行啊 ?
------解决方案--------------------
CREATE TABLE A1 (
JOBID NUMBER (19) NOT NULL,
JOBNAME VARCHAR2 (27) CONSTRAINT CCC NOT NULL,
SALARY NUMBER)
TABLESPACE W
/
CREATE TABLE A3 (
JOBID NUMBER (19) NOT NULL,
SALARY NUMBER)
TABLESPACE W
/
这样不就可以了吗,非得用分号啊。sqlplus中 分号代表一行结尾, '/ '才代表执行