摘要:
-- 日期查询 select * from tbl_member ts where password = '56a5aa0561ddd3b88b924315043cf6fb' and to_char(ts.password_modified_date,'yyyy-mm-dd hh:mi:ss') = 阅读全文
摘要:
MERGE INTO TBL_MEMBER TM -- 网站会员注册信息表USING( SELECT CHA_CDE, CHA_NME, CHA_ABBR, DPT_CDE, STATUS_CHA, AUTH_FLAG, CHA_MRK, CHA_CLS, 0 || SUBSTR(CHA_TYPE, 阅读全文