Waite的博客

create or replace procedure pro_Supplement_Leave_Mapping AS CURSOR TEMP_CUR IS select d.table_name, d.comments, t.num_rows from user_tab_comments d inner join user_tables t on d.table_name = t.TABLE_NAME left join user_col_comments c on ...

SQL创建定时任务例子：--每天两点执行存储过程    Declare      i Integer;    Begin       dbms_job.submit(i,'Update_Msg_Content;',Sysdate,'TRUNC(sysdate+1)+2/24');    end;--i job的值，'Update_Msg_Content;'存储过程的值，