oracle 字符最后位置,Oracle 字符串截取和位置

最新推荐文章于 2023-09-12 16:59:09 发布

weixin_39660408

最新推荐文章于 2023-09-12 16:59:09 发布

阅读量400

点赞数

文章标签： oracle 字符最后位置

UPDATE DCS_RESERVED_MARKIT_AMOUNTDETAILS SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_CALLSCHEDULE SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_CASHFLOWDETAILS SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_ENTITYDETAILS SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_INSTRUMENT SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_INTERESTSCHEDULE SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_ORGANIZATIONDETAILS SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_ORGANIZATIONINDUSTRYCLASSIFICATION SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_PUTSCHEDULE SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

UPDATE DCS_RESERVED_MARKIT_TRADINGANDSELLINGRESTRICTIONDETAILS SET CHECK_TIME = TO_DATE(substr(OPER_USER,instr(OPER_USER,'-')+1,8)||'084000','YYYYMMDDHH24MISS') WHERE CHECK_TIME>=TRUNC(SYSDATE) AND substr(OPER_USER,instr(OPER_USER,'-')+1,8)

标签：OPER,SYSDATE,instr,截取,substr,字符串,USER,Oracle,TRUNC

来源： https://www.cnblogs.com/zhanglin123/p/14479444.html