#昨天是导入,今天是导出,但是感觉好像缺点什么....
#!/bin/sh
tab=$1
path="$2"
if [ "X$tab" = "X" ]
then
echo "Usage: `basename $0` tablename "
exit
fi
if [ "X$path" = "X" ]
then
file=$tab
else
file=$path
fi
sqlplus -S /nolog >/dev/null <<!
conn $INIT_USING_DBASE/$INIT_USING_DBASEPWD
SET HEADING OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SET FLUSH OFF
SET LINES 1000
SET TRIMOUT ON
SET TRIMSPOOL ON
spool ${tab}_$$.tmp
SELECT * FROM $tab;
spool off
!
awk '{c=1
while(c<=NF)
{
printf("%s|",$c)
c++
}
printf("\n")
}' ${tab}_$$.tmp > $file.cfg
rm -f ${tab}_$$.tmp
导出数据库表中数据
最新推荐文章于 2023-01-09 14:27:43 发布