查询2016年8月31以后的信息
select * from ms_infodiscuss info where info.dtcreatdate>to_date('2016-08-31','yyyy-MM-dd')
-----定时任务
.//创建存储过程
create or replace procedure p_test as
begin
insert into tb_user values('10000','new_name','new_address');
end;
//执行存储过程
Declare
i Integer;
Begin
dbms_job.submit(i,'p_test;',Sysdate,'sysdate+1/1440');
end;
//查看已经创建的定时任务
Select * From user_jobs;<pre name="code" class="sql">--关闭定时任务
Declare
job_num Integer;
Begin
Select t.JOB into job_num From User_Jobs t;
dbms_job.broken(job_num,True);
end;