oracle创建造表,造出发器,序列...

1、造表
CREATE TABLE COMPANY_ABATE (
ID number(11) NOT NULL ,
TITLE varchar2(100) default NULL,
COMPANY_ID number(11) default NULL,
DISCOUNT number(10,2) default NULL,
BEGIN_TIME date default NULL,
END_TIME date default NULL,
INTRO varchar2(2000) default NULL,
PHOTO_PATH varchar2(255) default NULL,
state number(1) default 0,
companyName varchar2(50) default NULL,
userId number(11) default NULL,
PRIMARY KEY (ID)
) ;


2、建序列
CREATE SEQUENCE 表名_ID_SEQ INCREMENT BY 1 START WITH 1;
例子:   CREATE SEQUENCE COMPANY_PRODUCT_ID_SEQ INCREMENT BY 1 START WITH 1;

3、建触发器

CREATE OR REPLACE TRIGGER 表名_ID_TRG BEFORE INSERT ON 表名 FOR EACH ROW
BEGIN
IF :NEW.自增字段 IS NULL THEN
    SELECT 表名_ID_SEQ.NEXTVAL INTO :NEW.自增字段 FROM DUAL;
END IF;
END;
/

例子:
CREATE OR REPLACE TRIGGER COMPANY_PRODUCT_ID_TRG BEFORE INSERT ON COMPANY_PRODUCT FOR EACH ROW
BEGIN
IF :NEW.ID IS NULL THEN
    SELECT COMPANY_PRODUCT_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END IF;
END;
/