写脚本的一点东西
#!/bin/ksh
function xxxxxxxx
{
sqllog=/home/oracle/sqllog.log
su - oracle -c "sqlplus / as sysdba >${sqllog} "<< EOF
CREATE OR REPLACE PROCEDURE COMPARE_TABLES
AS
inde number;
ndeplevel number;
BEGIN
inde:=1;
ndeplevel:=1000;
while inde <= ndeplevel loop
xxxxxxxxxxxxxxxx;
commit;
inde:=inde+1;
end loop;
commit;
END COMPARE_TABLES;
/
exec COMPARE_TABLES;
exit
EOF
COUNT="$?"
if [ $COUNT -eq 0 ]; then
echo "xxxx success!"
fi
typeset result=`grep "ERROR" ${sqllog}`
if [ "X${result}" != "X" ];then
cat ${sqllog}
return 1
fi
result=`grep "Not connected" ${sqllog}`
if [ "X${result}" != "X" ];then
cat ${sqllog}
return 1
fi
return 0
}
xxxxxxxx $?