当前位置: 代码迷 >> Oracle开发 >> 大家帮忙看看这个触发器,在触发器中记录当前时间
  详细解决方案

大家帮忙看看这个触发器,在触发器中记录当前时间

热度:60   发布时间:2016-04-24 06:36:46.0
【求助】大家帮忙看看这个触发器,在触发器中记录当前时间
业务:
在插入一条数据时,将满足条件的数据转移至另一张表,并在import_time中记录系统当前时间

表1:
desc YTO_ORDERDETAIL_TABLE 
名称                             空值       类型                                                                                                                                                                                            
------------------------------ -------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
PRODUCTNO                      NOT NULL VARCHAR2(800)                                                                                                                                                                                 
PARTID                                  VARCHAR2(800)                                                                                                                                                                                 
PARTNO                         NOT NULL VARCHAR2(800)                                                                                                                                                                                 
SUPPLIERNO                              VARCHAR2(800)                                                                                                                                                                                 
  相关解决方案