sql> set serverout on
sql> exec sp_test_next_date();
job执行中的next_date: 2004-12-02 00:44:11
pl/sql 过程已成功完成。
sql> col next_date for a20
sql> select to_char(next_date,'yyyy-mm-dd hh24:mi:ss') next_date from user_jobs
where what = 'sp_test_next_date;';
next_date
--------------------
