shell导出oracle表数据类型,shell读取oracle表并输出为文件

set head off;

set pagesize 0;

set linesize 160;

col DTIME1 format a20;

define dir='/home/oracle/shell/daily';

spool &dir/tmp_dailyswitch.lst;

select t.DTIME||','||t.PORTID||','||t.SWITCHID||','||t.INTERBANDWIDTH||','||t.INBYTES||','||t.INSINGLEPKG||','||

t.INLOSTPKG||','||t.INERRPKG||','||t.OUTBYTES||','||t.OUTSINGLEPKG||','||t.OUTLOSTPKG||','||t.OUTERRPKG||','||

t.INBROADCASTPKG||','||t.OUTBROADCASTPKG||','||t.UNKNOWNPORTLOSTPKG from t_base_switchport_${Day} t where

t.switchid='NE=C3MgrZone1111111112333' and t.portid  in ('Ten-GigabitEthernet1/4/0/4','Ten-GigabitEthernet1/5/0/4');

spool off;

spool &dir/tmp_dailyroute.lst;

select t.DTIME||','||t.PORTID||','||t.ROUTERID||','||t.INTERBANDWIDTH||','||t.INBYTES||','||t.INSINGLEPKG||','||

t.INLOSTPKG||','||t.INERRPKG||','||t.OUTBYTES||','||t.OUTSINGLEPKG||','||t.OUTLOSTPKG||','||t.OUTERRPKG||','||

t.INBROADCASTPKG||','||t.OUTBROADCASTPKG||','||t.UNKNOWNPORTLOSTPKG from t_base_routerport_${Day} t where

routerid='NE=C3MgrZone1111111112333' and t.portid in ('xe-0/0/0','xe-0/0/1','xe-0/1/0','xe-1/0/0','xe-1/0/1');

spool off;

define dir

quit

EOF

echo

"DTIME,PORTID,SWITCHID,INTERBANDWIDTH,INBYTES,INSINGLEPKG,INLOSTPKG,INERRPKG,OUTBYTES,OUTSINGLEPKG,OUTLOSTPKG,OUTERRPKG,INB

ROADCASTPKG,OUTBROADCASTPKG,UNKNOWNPORTLOSTPKG" > /home/oracle/shell/daily/dailyswitch/dailyswitch_${Day}

cat /home/oracle/shell/daily/tmp_dailyswitch.lst | grep . >> /home/oracle/shell/daily/dailyswitch/dailyswitch_${Day}

echo

"DTIME,PORTID,ROUTERID,INTERBANDWIDTH,INBYTES,INSINGLEPKG,INLOSTPKG,INERRPKG,OUTBYTES,OUTSINGLEPKG,OUTLOSTPKG,OUTERRPKG,INB

ROADCASTPKG,OUTBROADCASTPKG,UNKNOWNPORTLOSTPKG" > /home/oracle/shell/daily/dailyroute/dailyroute_${Day}

cat /home/oracle/shell/daily/tmp_dailyroute.lst | grep . >> /home/oracle/shell/daily/dailyroute/dailyroute_${Day}

exit 0

在excel表打开用分列选择逗号为分隔符。