创建序列
create sequence JZ_CEMENT_RESEARCH_ID_SEQ
minvalue 1
nomaxvalue
increment by 1
start with 1
nocache;
创建触发器
create or replace trigger JZ_CEMENT_RESEARCH_TRG
before insert on JZ_CEMENT_RESEARCH for each row
begin
select SEQ_JZ_CEMENT_RESEARCH_ID.nextval into:new.id from dual;
end;
查询当前用户序列
select * from user_sequences
删除序列
drop sequence MRK_MARKET_80658_SEQ;
查询所有
select * from all_sequences
查询触发器
Select object_name From user_objects Where object_type='TRIGGER';
系统时间戳
(sysdate - to_date('1970-01-01 08:00:00', 'yyyy-mm-dd hh24:mi:ss')) * 24 * 60 * 60 * 1000