在你的表上创建序列和触发器!!例如:create sequence m_Feature(序列名)
start with 1
increment by 1
minvalue 1
maxvalue 10000000
cache 20
cycle
order
;
CREATE OR REPLACE TRIGGER Feature_OATOADD_ID(触发器名) BEFORE
INSERT ON Feature(表名)
FOR EACH ROW
declare
next_seq_id integer;
begin
select m_Feature(序列名).nextval into next_seq_id from dual;
:new.FeatureID(自动增量的列名) := next_seq_id;
end;
/
start with 1
increment by 1
minvalue 1
maxvalue 10000000
cache 20
cycle
order
;
CREATE OR REPLACE TRIGGER Feature_OATOADD_ID(触发器名) BEFORE
INSERT ON Feature(表名)
FOR EACH ROW
declare
next_seq_id integer;
begin
select m_Feature(序列名).nextval into next_seq_id from dual;
:new.FeatureID(自动增量的列名) := next_seq_id;
end;
/
或者到“FAQ”中去找找,你会很高兴的发现,已经
有人提出解决办法了。
2、详细说明什么日期问题。
CREATE SEQUENCE id
NOCYCLE
MAXVALUE 9999999999
START WITH 1;然后insert into tab_name values(id.nextval,....)
create sequence 表名_seq increment by 1 start with 1 maxvalue 99999
select 表名_seq.nextval from 表名;
2.通过函数to_char(sysdate,'yyyymmdd')可以将其转成需要的任何格式