job来做SQL> create or replace procedure your_task is
2 i pls_integer;
3 begin
4 select count(*) into i from all_sequences where lower(sequence_name)='your_seq';
5 if i>0 then
6 execute immediate 'drop sequence your_seq';
7 end if;
8 execute immediate 'create sequence your_seq start with 1 nocache';
9 execute immediate 'select your_seq.nextval from dual';
10 end;
11 /过程已创建。SQL> var job number
SQL> exec dbms_job.submit(:job,'your_task;',trunc(sysdate),'trunc(sysdate)+1');PL/SQL 过程已成功完成。SQL> print job JOB
----------
84SQL> exec dbms_job.run(84);PL/SQL 过程已成功完成。
2 i pls_integer;
3 begin
4 select count(*) into i from all_sequences where lower(sequence_name)='your_seq';
5 if i>0 then
6 execute immediate 'drop sequence your_seq';
7 end if;
8 execute immediate 'create sequence your_seq start with 1 nocache';
9 execute immediate 'select your_seq.nextval from dual';
10 end;
11 /过程已创建。SQL> var job number
SQL> exec dbms_job.submit(:job,'your_task;',trunc(sysdate),'trunc(sysdate)+1');PL/SQL 过程已成功完成。SQL> print job JOB
----------
84SQL> exec dbms_job.run(84);PL/SQL 过程已成功完成。
在windows2000下可以用:
sqlplus DB_user/DB_password@DB_Name<YourSql.sql
当然,你要将这句话写到批处理文件中我就是这样做的。