ããoracleæ¥è¯¢è¡¨ä¸æ°æ®è¡(row)ä¸æåçDMLæ¶é´
ãã第ä¸ç§æ¹å¼ï¼å级è·è¸ªï¼ï¼
ããselect ora_rowscn,
ããdbms_rowid.ROWID_BLOCK_NUMBER(rowid) blockid,scn_to_timestamp(ora_rowscn)
ããfrom hs_futures.fuentrust t
ããorder by scn_to_timestamp(ora_rowscn);
ããdbms_rowid.ROWID_BLOCK_NUMBER(rowid)ï¼æ¯ä¸ºè·åæ°æ®æå¨åçIDscn_to_timestamp(ora_rowscn)ï¼è·åæ°æ®ææä¿®æ¹çæ¶é´æ°æ®åç°åååéè¿ä¸é¢SQLè¯å¥å¯ä»¥æ¥çå°æ°æ®æåä¿®æ¹çæ¶é´ï¼æ³¨æå 为æ¯åä¸ä¸ªåä¸ï¼æ以è¿ä¸ªåä¸åªè¦æDMLæä½é£ä¹æææ°æ®çscné½æ´æ°äºï¼æ以å¡æ¯è·è¿æ¡è®°å½å¨åä¸ä¸ªåä¸æ°æ®è·åå°çora_rowscnåscn_to_timestamp(ora_rowscn)两个å¼é½åçäºç¸åºçååã
ãã第äºç§æ¹å¼ï¼è¡çº§è·è¸ªï¼ï¼
ããcreate table hs_futures.fuentrust_test1 rowdependencies asselect * from hs_futures.fuentrust
ããç¨ä»¥ä¸è¯å¥å建ä¸ä¸ªåºäºROWDEPENDENCIES模å¼ç表ï¼ç¶åç¨ç¬¬ä¸ç§æ¹æ³ä¸çSQLå»æ¥è¯¢æ¤è¡¨æ°æ®ä¸çora_rowscnï¼scn_to_timestamp(ora_rowscn)两个å¼ï¼ä¿®æ¹å
¶ä¸çæä¸æ¡è®°å½ç¶ååå»æ¥è¯¢é£ä¸ªå¼åç°åçååçåªæ¯è¢«ä¿®æ¹é£æ¡è®°å½çè¿ä¸¤ä¸ªå¼åçäºååï¼èå¨åä¸ä¸ªåä¸æ²¡æ被修æ¹çå
¶å®è®°å½è¿ä¸¤ä¸ªå¼æ¯ä¸ä¼äº§çååçã
温馨提示:答案为网友推荐,仅供参考