oracle中刪除重復(fù)記錄-閱讀頁
2025-05-28 22:33本頁面
【正文】 *error at line 1:ora02299: cannot validate () duplicate keys foundsqlcreate table dups as select * from cz where rowid in (select row_id from exceptions)。 c1 c10 c20 1 2 dsf 1 2 dsf 1 2 dsf 1 2 dsf 2 3 che 1 2 dsf 1 2 dsf 1 2 dsf 1 2 dsf 2 3 che 2 3 che 2 3 che 2 3 che 3 4 dff 3 4 dff 3 4 dff16 rows selected.sqlselect row_id from exceptions。16 rows deleted.sqlinsert into cz select distinct * from dups。 c1 c10 c20 1 2 dsf 2 3 che 3 4 dff 4 5 err 5 3 dar 6 1 wee 7 2 zxc7 rows selected.從結(jié)果里能看到重復(fù)記錄已刪除
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1