Oracle建表语句

/*
Navicat Oracle Data Transfer
Oracle Client Version : 10.2.0.5.0

Source Server         : 127.0.0.1_MONITOR
Source Server Version : 110200
Source Host           : 127.0.0.1:1521
Source Schema         : MONITOR_USER

Target Server Type    : ORACLE
Target Server Version : 110200
File Encoding         : 65001

Date: 2018-07-16 15:06:43
*/

-- ----------------------------
-- Table structure for PDF
-- ----------------------------
DROP TABLE "GRID";
CREATE TABLE "GRID" (
"ID" NUMBER NOT NULL ,
"GRID_NAME" VARCHAR2(255 BYTE) DEFAULT NULL  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT NULL  NULL ,
"EFFECT_TIME"  TIMESTAMP(6)  DEFAULT NULL  NULL ,
"POINT_NUM" number,
"GRID_POINTS" VARCHAR2(255 BYTE) DEFAULT NULL  NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- Create sequence 
create sequence GRID_ID_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
nocache;

-- ----------------------------
-- Indexes structure for table GRID
-- ----------------------------

-- ----------------------------
-- Triggers structure for table GRID
-- ----------------------------
CREATE OR REPLACE TRIGGER "GRID_INS_TRG" BEFORE INSERT ON "GRID" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW ENABLE WHEN (NEW.ID IS NULL)
BEGIN
SELECT GRID_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
-- ----------------------------
-- Checks structure for table GRID
-- ----------------------------
ALTER TABLE "GRID" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "GRID" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table GRID
-- ----------------------------
ALTER TABLE "GRID" ADD PRIMARY KEY ("ID");