CREATE TABLE SYSTEM.PARENT_0812222300
AS SELECT * FROM SYSTEM.PARENT
《正常结束》DROP TABLE SYSTEM.PARENT
《正常结束》CREATE TABLE SYSTEM.PARENT
(
ID NUMBER(10,0) NOT NULL PRIMERY KEY,
NAME NVARCHAR2(20),
PRORITY NUMBER(1,0),
STUID NUMBER(10,0) NOT NULL,
RELSHIP NVARCHAR2(4),
EMAIL NVARCHAR2(25),
PASSWORD NVARCHAR2(20) NOT NULL,
PHONENO VARCHAR2(13) NOT NULL
)
PCTFREE 10
PCTUSED 40
MAXTRANS 255
TABLESPACE SYSTEM
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
《错误》ORA-00922: 缺少或无效选项
AS SELECT * FROM SYSTEM.PARENT
《正常结束》DROP TABLE SYSTEM.PARENT
《正常结束》CREATE TABLE SYSTEM.PARENT
(
ID NUMBER(10,0) NOT NULL PRIMERY KEY,
NAME NVARCHAR2(20),
PRORITY NUMBER(1,0),
STUID NUMBER(10,0) NOT NULL,
RELSHIP NVARCHAR2(4),
EMAIL NVARCHAR2(25),
PASSWORD NVARCHAR2(20) NOT NULL,
PHONENO VARCHAR2(13) NOT NULL
)
PCTFREE 10
PCTUSED 40
MAXTRANS 255
TABLESPACE SYSTEM
STORAGE(INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
NOCACHE
LOGGING
《错误》ORA-00922: 缺少或无效选项
ID NUMBER(10,0) NOT NULL PRIMERY KEY,
--改成 PRIMARY 写错了。
ID NUMBER(10,0) NOT NULL PRIMARY KEY,
ID NUMBER(10,0) NOT NULL PRIMERY KEY,
--改成 PRIMARY 写错了。
ID NUMBER(10,0) PRIMARY KEY,
ID number(10,0) not null primary key