oracle
ttnt1984
这个作者很懒,什么都没留下…
展开
-
设置oracle主键ID的触发器
DROP SEQUENCE SEQ1CREATE SEQUENCE SEQ1INCREMENT BY 1START WITH 1MAXVALUE 999999999999;DROP TRIGGER SET_IDCREATE OR REPLACE TRIGGER SET_ID BEFORE INSERT ON table FOR EACH ROWDECLARE ID number;B原创 2007-06-27 11:35:00 · 574 阅读 · 0 评论 -
oracle定时任务配置
create or replace procedure P_testisbegindbms_output.put_line(这是系统测试);end P_test;declare jobno number;begin dbms_job.submit(jobno,P_test;,trunc(last_day(sysdate)+1),trunc(last_day(add_months(原创 2007-06-27 11:46:00 · 590 阅读 · 0 评论