vi csv_convert.sh

#!/bin/sh

CSV_FILE="/home/rock1223/csv/out.csv"
QUERY_STR="select "'*'" from all_tables;"
SQL_COMMAND="tbsql -s sys/tibero"

RESULT=`$SQL_COMMAND <<EOF
set pagesize 0 feedback off ver off heading off echo off
set pages 0 colsep ',' trimspool on lines 30000 termout off
spool $CSV_FILE
$QUERY_STR
spool off
quit
/
EOF
`

#echo $RESULT