qq_28778935的博客

declarejob1 number;begin dbms_job.submit(　　job1,--定时器ID，系统自动获得　　'PRC_INSERT;', --what执行的过程名　　 sysdate,--next_date,定时器开始执行的时间，这里表示立即执行　　'sysdate + 1/1440'--interval,每隔1分钟执行一次

create temporary tablespace temp_1 tempfile 'E:\temp_1.dbf' size 20M autoextend on;//在E盘创建20M的表空间create tablespace ts_1 datafile 'E:\ts_1.dbf' size 20M autoextend on;create user user1 identified b

SELECT t."NAME",TC.TASK_STATE,count(1),sum(case when tc.task_time where t.id = TC.TASK_ID and tc.task_STATE != 3 and tc.task_STATE != (case when t.NAME = '客户续保' then 2 else 4 end) GROUP BY t."NAME

SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM TABLE_NAME) A WHERE ROWNUM = 21