将Ox17转换为特定的字符串,比如; 可以这样写 export to /home/nccwykpi/del/1990/S03_IM_LOG.dat of del modified by nochardel coldel0x1b select LOG_USERID, LOG_DATETIME, &nbs...
显示全部将Ox17转换为特定的字符串,比如; 可以这样写
export to /home/nccwykpi/del/1990/S03_IM_LOG.dat of del modified by nochardel coldel0x1b
select
LOG_USERID,
LOG_DATETIME,
LOG_BSNCODE,
BDF_NAME,
LOG_OPEROBJTYPE,
BRH_NAME,
LOG_OPEROBJID,
USR_BRANCHID,
varchar(LOG_LOGNO)||';'
from ODS.DATA_IM_LOG
where LOG_USERID like '1990%';
收起