摘要: truncate table DWDM2.tablename IMMEDIATE;alter table DWDM1.tablename activate not logged initially with empty table;but which one is... 阅读全文
posted @ 2016-05-04 20:16 yuerspring 阅读(696) 评论(0) 推荐(0) 编辑
摘要: select num, listagg(DSCR, ',') WITHIN GROUP(ORDER BY DSCR) as DSCRfrom DWDM2.QUOTE_TEMP where DSCR != 'E0003' group by num with ... 阅读全文
posted @ 2016-05-04 08:16 yuerspring 阅读(480) 评论(0) 推荐(0) 编辑