1.创建表:
首先建表及字段:
CREATE TABLE MYTABLE(
ID NUMBER(12) NOT NULL,
NAME VARCHAR2(32) ,
DESP VARCHAR2(100),
AGE NUMBER(3),
BRITHDAY DATE DEFAULT SYSDATE
) TABLESPACE MYSPACE;
建立唯一主键:
ALTER TABLE MYTABLE ADD CONSTRAINT P_MT PRIMARY KEY (ID);
为ID建立序列:
CREATE SEQUENCE MYSEQUENCE INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCACHE;
建立触发器:
CREATE OR REPLACE TRIGGER MYTRIGGER BEFORE INSERT ON MYTABLE
FOR EACH ROW
BEGIN
IF(:NEW.ID IS NULL)
THEN
SELECT MYSEQUENCE.NEXTVAL INTO:NEW.ID FROM DUAL;
END IF;
END;
(建立序列与触发器是为了ID的自增)
创建好表后,可以用DESC命令查看:
DESC MYTABLE;