摘要：
原始数据： 方式一： select t_name, sum(decode(t_item, 'item1', t_num, 0)) item1, sum(decode(t_item, 'item2', t_num, 0)) item2, sum(decode(t_item, 'item3', t_nu 阅读全文
摘要：
导出数据 SQL> conn / as sysdba Connected. SQL> create directory lxw_dir as '/home/oracle'; Directory created. SQL> grant write,read on directory lxw_dir t 阅读全文