摘要: BEGINFOR L_RECORD IN (select RECORD_ID,CURR_PERIOD,PERIOD_START_DATE, (sysdate- PERIOD_START_DATE) diffTime,(P.PERIOD_END_DAY-P.PERIOD_BEGIN_DAY) peri... 阅读全文
posted @ 2015-03-01 02:27 走路到纽约 阅读(18511) 评论(0) 推荐(0) 编辑
摘要: --1.plsql中学习job --学习job --建表 create table test_job(para_date date); commit; insert into test_job values(sysdate); commit; select * from test... 阅读全文
posted @ 2015-03-01 00:13 走路到纽约 阅读(2884) 评论(0) 推荐(0) 编辑