Oracle 判断表是否已完全刷新当天数据
发布时间:2020-12-12 14:19:43 所属栏目:百科 来源:网络整理
导读:需求:当天备份表刷新完数据后,拉取当天数据。 问题:备份表需要刷新完,才拉取数据 解决: SELECT t.inv_date FROM rmsbak.cmx_item_loc_soh_bak t WHERE 1 = 1 AND t.inv_date = trunc(SYSDATE) AND rownum = 1 AND NOT EXISTS (SELECT object_name FROM
需求:当天备份表刷新完数据后,拉取当天数据。 问题:备份表需要刷新完,才拉取数据 解决: SELECT t.inv_date FROM rmsbak.cmx_item_loc_soh_bak t WHERE 1 = 1 AND t.inv_date = trunc(SYSDATE) AND rownum = 1 AND NOT EXISTS (SELECT object_name FROM gv$locked_object l,dba_objects o WHERE l.object_id = o.object_id AND o.object_name = upper('RMSBAK') AND o.object_name = upper('CMX_ITEM_LOC_SOH_BAK')); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |