庄周梦蝶的博客网

版权声明：转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://yanchang.yourblog.org/logs/420469.html

下午3点,处理工行后督业务调整的一些问题 1 原添加地区号不用对程序做改动 2 数据库备份和运行慢的问题 ------------------------------------------------------------------------------------------------- --ptas.mainframe_balance_log1 insert into mainframe_balance_log1(brno,tellerno,workdate,trxcode) select brno,tellerno,workdate,trxcode from ocr_ptas group by brno,tellerno,workdate,trxcode; commit; --ptas.mainframe_balance_log2 insert into mainframe_balance_log1(brno,tellerno,workdate,trxcode) select brno,tellerno,workdate,trxcode from mainframe_balance_log2 where brno in(2001,2088,2227,2361,2398,2399,2400,2401,2402,2406,2443,2444,2445,2446,2539,2550,2807,2838,2981) group by brno,tellerno,workdate,trxcode; commit; exit SQL> desc MAINFRAME_BALANCE_LOG1; 名称 是否为空？类型 ------------------------------- -------- ---- BRNO NUMBER(5) TELLERNO NUMBER(5) TRXCODE NUMBER(5) WORKDATE CHAR(10) ISACTIVE NUMBER(1) ÷