随手记（一）

存储过程中，用同义词组建相应表名：

EXECUTE IMMEDIATE 'CREATE OR REPLACE SYNONYM SYN_STR_GSM_GPRS FOR ODS.tb_pre_' ||P_ACCT_DAY;

EXECUTE IMMEDIATE 'CREATE OR REPLACE SYNONYM SYN_STR_OCS_GPRS FOR ODS.tb_pre_' ||SUBSTR(V_MONTH, -2);

 

tns_file:

$ORACLE_HOME\network\admin\tnsnames.ora

 

sqludr2.bin:

sqluldr2.bin safe=yes user=$CONNECT_BSS  query="$v_query" log="$v_sqlload_logfile" field=0x01 record=0x0A ncharset="CHINESE_CHINA.ZHS16GBK" charset="UTF8" file="$v_datafile"