没有这种类型
可以创建 sequence 来 模拟一下,例如:create sequence tbl_seq minvalue 1 maxvalue 999999999999999999999999999 increment by 1 start with 1 cache 20 noorder nocycle;
可以创建 sequence 来 模拟一下,例如:create sequence tbl_seq minvalue 1 maxvalue 999999999999999999999999999 increment by 1 start with 1 cache 20 noorder nocycle;
例如:
DROP SEQUENCE SEQ_DOCUMENT;
CREATE SEQUENCE SEQ_DOCUMENT
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999999999
CYCLE
CACHE
ORDER;
COMMIT;
CREATE OR REPLACE TRIGGER TRG_ADDDOCUMENT
BEFORE INSERT ON T_DOCUMENTINFO
FOR EACH ROW
BEGIN
SELECT SEQ_DOCUMENT.NEXTVAL INTO :NEW.SN FROM DUAL;
END TRG_ADDDOCUMENT;