Oracle建表建序列

建表语句：

CREATE TABLE IONA_WHITE_LIST(
ID NUMBER(22) PRIMARY KEY NOT NULL,
DATA_SOURCE VARCHAR2(20),
HIDDEN_DANGER_BUSINESS VARCHAR2(20),
HIDDEN_PARAGRAPHS VARCHAR2(255),
HIDDEN_LANG VARCHAR2(50),
CITY_NAME VARCHAR2(32),
SPEC_EQUIPMENT VARCHAR2(20),
SPEC_NAME VARCHAR2(255),
CUS_HIDDEN_LEVEL VARCHAR2(10),
CUR_HIDDEN_LEVEL VARCHAR2(10),
UPDATE_TIME DATE
)

给表字段添加备注：

COMMENT ON TABLE IONA_WHITE_LIST  IS '隐患点白名单表';
  COMMENT ON COLUMN IONA_WHITE_LIST.ID IS '白名单ID';
  COMMENT ON COLUMN IONA_WHITE_LIST.DATA_SOURCE IS '所属来源（数据来源）:长途、本地';
  COMMENT ON COLUMN IONA_WHITE_LIST.HIDDEN_DANGER_BUSINESS IS '隐患点所属业务场景：为IPRAN分析、MSE分析';
  COMMENT ON COLUMN IONA_WHITE_LIST.HIDDEN_PARAGRAPHS IS '隐患点段落'
  COMMENT ON COLUMN IONA_WHITE_LIST.HIDDEN_LANG IS '隐患点长度'
  COMMENT ON COLUMN IONA_WHITE_LIST.CITY_NAME IS '设备所属地市'
  COMMENT ON COLUMN IONA_WHITE_LIST.SPEC_EQUIPMENT IS '所属设备专业：枚举：IPRAN、IP、IDC、传输'
  COMMENT ON COLUMN IONA_WHITE_LIST.SPEC_NAME IS '为隐患段落对应的设备名称集合';
  COMMENT ON COLUMN IONA_WHITE_LIST.CUS_HIDDEN_LEVEL IS '原隐患等级,枚举： A/B/C/D';
  COMMENT ON COLUMN IONA_WHITE_LIST.CUR_HIDDEN_LEVEL IS '白名单隐患等级：枚举： A/B/C/D';     
  COMMENT ON COLUMN IONA_WHITE_LIST.UPDATE_TIME IS '数据更新时间';

给自增ID添加序列：

CREATE SEQUENCE SEQ_IONA_WHITE_LIST 
  MINVALUE 1
  MAXVALUE 9999999
  START WITH 1
  INCREMENT BY 1

自增ID取值（使用序列）：

SEQ_IONA_WHITE_LIST.NEXTVAL：取下一个值，自增，默认值为初始值

SEQ_IONA_WHITE_LIST.CURRVAL：始终取当前值

比如，做插入操作：

 INSERT INTO IONA_WHITE_LIST
      (ID,DATA_SOURCE,
       HIDDEN_DANGER_BUSINESS,
       HIDDEN_PARAGRAPHS,
       HIDDEN_LANG,
       CITY_NAME,
       SPEC_EQUIPMENT,
       SPEC_NAME,
       CUS_HIDDEN_LEVEL,
       CUR_HIDDEN_LEVEL,
       UPDATE_TIME)
    VALUES
      (SEQ_IONA_WHITE_LIST.NEXTVAL,'长途','MSE分析','A-N','20km','深圳','IPRAN','xxx','C','D',to_date('2019-05-06','yyyy-MM-dd'));