利用linux进行oracle数据查询，并将大文件拆分小文件

# version:V202209-1.0,author:Pavin_Wu,des:...
# V202209,1.get the fileSize from table "FILED_VALUES"
filePath=/home/oracle/LOG
prefixSplit=split_file_
fileName=test.log
numReg='^[0-9]+$'
defaultFileSize=500000

# select the result from oracle database, and put the value into fileSzie
fileSzie=`sqlplus -S system/123456@//127.0.0.1:1521/helowin << eof
whenever sqlerror exit failure rollback
set heading off
set verify off
set feedback off
set tab off
set pagesize 0
set linesize 1000

select FIELD_VALUE1 from SYSTEM.FIELD_VALUES WHERE FIELD_NAME='SPLIT_FILE_SIZE';
exit
eof`

# check the result, set default value if necessary
echo $fileSzie
if ! [[ $fileSzie =~ $numReg ]] ; then
   echo "error: Not a number.Given a default valuse:50w" >&2;
   fileSzie=$defaultFileSize;
fi
echo $fileSzie

# split big file into small files
split -$fileSzie $filePath/$fileName $filePath/$prefixSplit

# handle your function,here
for v_file_name in `ls $filePath/$prefixSplit*`;
do
  grep -iw "^input" ${v_file_name}
  echo $v_file_name
  if [ $? != 0 ] ; then
   echo "error: exec for";
   exit 1
  fi
done

echo -e "hellow cis"
exit 0