UPDATE AQSIQ_WS_PASSPORT_INFO set BORROW_STATUS='已归还' , RETURN_DATE=TO_CHAR(SYSDATE) WHERE ','||388008900535402||',' LIKE '%,'||TO_CHAR(INFO_CODE)||',%';报invalid number错误怎么解决
UPDATE AQSIQ_WS_PASSPORT_INFO set BORROW_STATUS='已归还' , RETURN_DATE=TO_CHAR(SYSDATE) WHERE ','||'388008900535402'||',' LIKE '%,'||TO_CHAR(INFO_CODE)||',%';
TO_CHAR(SYSDATE) TO_CHAR(SYSDATE,'yyyymmdd')
Like 用反了 UPDATE AQSIQ_WS_PASSPORT_INFO set BORROW_STATUS='已归还' , RETURN_DATE=TO_CHAR(SYSDATE) WHERE TO_CHAR(INFO_CODE) LIKE '%388008900535402%';
TO_CHAR(SYSDATE,'yyyymmdd')
UPDATE AQSIQ_WS_PASSPORT_INFO set BORROW_STATUS='已归还' , RETURN_DATE=TO_CHAR(SYSDATE)
WHERE TO_CHAR(INFO_CODE) LIKE '%388008900535402%';