17,377
社区成员
发帖
与我相关
我的任务
分享
execute immediate
'SELECT COUNT(*) FROM HITBCASE.'||TABLENAME ||' WHERE DISTRICT='||P.DSTCODE||' AND TO_CHAR(CREATED,''YYYY-MM-DD HH24:MI:SS'')
BETWEEN TO_CHAR(TRUNC(SYSDATE-1))||'' 05:30:00'' AND TO_CHAR(TRUNC(SYSDATE))||'' 05:29:59''' INTO SUCESS ;