#自己写的脚本,发上来主要是交流,因为是新手,所有脚本中有很多不足和优化的地方,希望不吝赐教。。。偶深深的鞠躬感谢!
#代码丑陋,看客轻拍
#!/bin/sh
tab=""
keyword=""
field=""
USER=""
usage()
{
cat<<!
Usage: mk_ctl -u[user/passwd] -t[table] -k[keyword] -f[fileds] -h[help]
!
}
help()
{
echo "Using: `basename $0`"
echo "-u: DBASE/DBASEPWD"
echo "-t: export table name."
echo "-k: keyword--default is append;option:[append|replace|insert]."
echo "-f: instead of your field to |."
}
conn()
{
if [ -z "$USER" ]
then
echo "没有指定-u选项,将使用默认环境变量!"
USER=$INIT_USING_DBASE/$INIT_USING_DBASEPWD
fi
sqlplus -S $USER >/dev/null <<!
set pages 0;
set concat on;
set trimspool on;
set termout off;
set show off;
set autoprint off;
set autotrace off;
s