用SQL命令行:
job:
variable job number; begin sys.dbms_job.submit(job => :job, what => 'clearseq(''SEQ_SN_ID'');', next_date => to_date('16-10-2012 18:37:20', 'dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(SYSDATE)+1/24+1'); commit; end; / variable job number; begin sys.dbms_j