NO.one的专栏

CREATE TABLE kc ("KCH" CHAR(3 byte) NOT NULL,     "KCM" CHAR(16 byte) NOT NULL, "KKXQ" NUMBER(1) NOT NULL, "XS"    NUMBER(2) NOT NULL, "XF" NUMBER(1),     CONSTRAINT "CHECK_KKXQ_1" CHECK(kkxq between

ORACLE没有象SQL SERVER中一样的自增加字段，要实现只能通过SEQUENCE来实现1.创建序列：create sequence your_seq nocyclemaxvalue 9999999999start with 1;   2.使用触发器实现自增：create or replace trigger your_seq_tribefore insert o