Question

shell脚本看不懂，求大神帮翻译翻译。工作任务着急啊，在线等

OracleRWAUser=rwa_test
OracleRWAPasswd=rwa_test
OracleRWADbName=rwabb
FTP_PATH=/rwaload/datareceive
#FTP_PATH=/rwaload/work/AA/20130402
WORK_PATH=/rwaload/work
WAIT_SECONDS=30
LONG_WAIT_SECONDS=60
#LogFile=/rwaload/log/MOVEFILE.log
TempFile=/rwaload/conf/temp.$$
DataFileList=/rwaload/conf/datafile.list

sqlplus -s $OracleRWAUser/$OracleRWAPasswd@$OracleRWADbName << EOFSQL
set heading off;
set termout off;
set feedback off;
set trimspool on;
set echo off;
set linesize 200;

spool $1
select file_name||'='||table_name from rwa_odm_sys_tablelist where txt_status='0' and status='0';
spool off;

EOFSQL

Answer 1

总之就是查询一下rwabb库的rwa_test用户下rwa_odm_sys_tablelist表里面txt_status='0'并且status='0'的记录。