CREATETABLE PERSON
(
ID NUMBERNOTNULL
, PERSON_NAME VARCHAR2(20) NOTNULL
, CONSTRAINT PRESON_PK PRIMARYKEY
(
ID
)
ENABLE
);
插入测试数据:
INSERTINTO PERSON (ID,PERSON_NAME) VALUES (1,'张三');INSERTINTO PERSON (ID,PERSON_NAME) VALUES (2,'李四');INSERTINTO PERSON (ID,PERSON_NAME) VALUES (3,'王五');INSERTINTO PERSON (ID,PERSON_NAME) VALUES (4,'赵六');INSERTINTO PERSON (ID,PERSON_NAME)