06 2023 档案
Oracle分批delete大表数据
摘要:分批DELETEDROP TABLE T3;CREATE TABLE T3 AS SELECT * FROM DBA_OBJECTS;DECLARE CURSOR MYCURSOR IS SELECT ROWID FROM T3 ORDER BY ROWID; --按ROWID排序的CURSOR,删 阅读全文
posted @ 2023-06-29 17:15 Leader.Z 阅读(290) 评论(0) 推荐(0)