Pavelyev/Oracle delete dublicates

Created April 29, 2015 09:18

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Pavelyev/637b89d1eee8f9cb041e.js"></script>
Save Pavelyev/637b89d1eee8f9cb041e to your computer and use it in GitHub Desktop.

Download ZIP

Raw

Oracle delete dublicates

-DELETE FROM
-   TABLE_NAME A
-WHERE
-  a.rowid >
-   ANY (
-     SELECT
-        B.rowid
-     FROM
-        TABLE_NAME B
-     WHERE
-        A.FIELD1 = B.FIELD1
-     AND
-        A.FIELD2 = B.FIELD2
-        );

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment