摘要:
SELECT OBJECT_NAME, MACHINE, S.SID, S.SERIAL# FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S WHERE L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID; ALTER SY... 阅读全文
摘要:
SELECT APC.APC_NAME, APC.APC_ID, PTC.PTI_NAME, TEMP.PTI_ID, TEMP.COUNTS, ROW_NUMBER() OVER (PARTITION BY APC.APC_ID ORDER BY TEMP.PTI_ID) ROW_NUMBERFR 阅读全文