PRC_S_SYS_LOG(4)

最新推荐文章于 2022-01-05 00:30:51 发布

jenya007

最新推荐文章于 2022-01-05 00:30:51 发布

阅读量269

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/jenya007/article/details/44451695

版权

Oracle 专栏收录该内容

227 篇文章 0 订阅

订阅专栏

update LBI_SYS_VDF.t_s_sys_log
           set end_time    = sysdate,
               task_status = 2,
               task_log    = 'program completed',
               row_count   = ii_rowcount
         where task_log <> 'performance debug'
           and task_id = oi_task_id
           and log_month = to_char(sysdate,'yyyymm');
    --add by l00233963 on 20140710 start
    elsif ( ii_task_status = 3 ) then
    /**
      * @description   get a new task id and insert a new record
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#log_month = (to_char(sysdate,'yyyymm'))
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_id = (oi_task_id)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_name = (is_task_name)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#table_name = (is_table_name)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_sign = (is_task_sign)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#start_time = current time(sysdate)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#end_time = (null)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_status = (1)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_log = ('program processing')
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_pos = (null)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#rowcount = (null)
      */